PREVIEW / stock_30min / 2010-02-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-16.parquet
  size:    1.3 MB
  rows:    72,829
  symbols: 3,469

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-02-16 04:30:00	AAPL	Stock	7.2107	7.2143	7.2107	7.2107	31332.0
2010-02-16 06:30:00	AAPL	Stock	7.1946	7.1946	7.1929	7.1929	5600.0
2010-02-16 07:00:00	AAPL	Stock	7.1757	7.1821	7.1757	7.1821	10640.0
2010-02-16 07:30:00	AAPL	Stock	7.1829	7.2054	7.1825	7.1893	25704.0
2010-02-16 08:00:00	AAPL	Stock	7.1854	7.1996	7.1846	7.1936	938084.0
2010-02-16 08:30:00	AAPL	Stock	7.1936	7.2064	7.1936	7.2064	640136.0
2010-02-16 09:00:00	AAPL	Stock	7.2064	7.2218	7.2039	7.2125	2426872.0
2010-02-16 09:30:00	AAPL	Stock	7.2125	7.2407	7.1971	7.2279	76973792.0
2010-02-16 10:00:00	AAPL	Stock	7.2279	7.2375	7.2143	7.2339	42532560.0
2010-02-16 10:30:00	AAPL	Stock	7.2337	7.2668	7.2304	7.2436	49361984.0
2010-02-16 11:00:00	AAPL	Stock	7.2443	7.2607	7.2379	7.2564	24264268.0
2010-02-16 11:30:00	AAPL	Stock	7.2571	7.27	7.255	7.2604	26483772.0
2010-02-16 12:00:00	AAPL	Stock	7.2607	7.2746	7.2579	7.2634	69392680.0
2010-02-16 12:30:00	AAPL	Stock	7.2627	7.2654	7.2514	7.2536	20638968.0
2010-02-16 13:00:00	AAPL	Stock	7.2539	7.2614	7.2396	7.2604	24874556.0
2010-02-16 13:30:00	AAPL	Stock	7.2607	7.2643	7.2429	7.2539	32685296.0
2010-02-16 14:00:00	AAPL	Stock	7.2529	7.2607	7.2439	7.255	19970468.0
2010-02-16 14:30:00	AAPL	Stock	7.2557	7.2621	7.2464	7.2596	17206224.0
2010-02-16 15:00:00	AAPL	Stock	7.2593	7.2679	7.2571	7.2671	21888384.0
2010-02-16 15:30:00	AAPL	Stock	7.2679	7.2743	7.2582	7.265	50328684.0
2010-02-16 16:00:00	AAPL	Stock	7.265	7.2665	7.2443	7.2625	24296272.0
2010-02-16 16:30:00	AAPL	Stock	7.2656	7.2656	7.2607	7.2618	585340.0
2010-02-16 17:00:00	AAPL	Stock	7.2629	7.2643	7.2607	7.2643	211092.0
2010-02-16 17:30:00	AAPL	Stock	7.2639	7.2671	7.2639	7.2643	114184.0
2010-02-16 18:00:00	AAPL	Stock	7.2643	7.2643	7.2611	7.2611	1161720.0
2010-02-16 18:30:00	AAPL	Stock	7.2654	7.2654	7.2614	7.2618	30688.0
2010-02-16 19:00:00	AAPL	Stock	7.2625	7.2625	7.2625	7.2625	11200.0
2010-02-16 19:30:00	AAPL	Stock	7.2625	7.2679	7.2625	7.2679	107772.0
2010-02-16 04:00:00	MSFT	Stock	28.17	28.17	28.17	28.17	200.0
2010-02-16 04:30:00	MSFT	Stock	28.06	28.06	28.06	28.06	100.0
2010-02-16 05:00:00	MSFT	Stock	28.06	28.06	28.06	28.06	500.0
2010-02-16 07:00:00	MSFT	Stock	28.06	28.06	28.03	28.03	700.0
2010-02-16 07:30:00	MSFT	Stock	28.03	28.03	28.0	28.0	800.0
2010-02-16 08:00:00	MSFT	Stock	28.04	28.07	28.02	28.07	16292.0
2010-02-16 08:30:00	MSFT	Stock	28.07	28.1	28.07	28.09	7327.0
2010-02-16 09:00:00	MSFT	Stock	28.1	28.15	28.09	28.14	21528.0
2010-02-16 09:30:00	MSFT	Stock	28.13	28.22	28.02	28.08	4979805.0
2010-02-16 10:00:00	MSFT	Stock	28.085	28.24	28.08	28.23	3142027.0
2010-02-16 10:30:00	MSFT	Stock	28.24	28.35	28.15	28.2	3910765.0
2010-02-16 11:00:00	MSFT	Stock	28.21	28.25	28.12	28.245	3085562.0
2010-02-16 11:30:00	MSFT	Stock	28.248	28.33	28.23	28.3	2386197.0
2010-02-16 12:00:00	MSFT	Stock	28.3	28.34	28.23	28.27	2297452.0
2010-02-16 12:30:00	MSFT	Stock	28.275	28.28	28.2	28.219	1870950.0
2010-02-16 13:00:00	MSFT	Stock	28.22	28.27	28.19	28.26	1733435.0
2010-02-16 13:30:00	MSFT	Stock	28.27	28.3	28.22	28.27	2560599.0
2010-02-16 14:00:00	MSFT	Stock	28.265	28.275	28.17	28.21	2592902.0
2010-02-16 14:30:00	MSFT	Stock	28.22	28.3	28.2	28.255	3797154.0
2010-02-16 15:00:00	MSFT	Stock	28.25	28.28	28.22	28.235	2959503.0
2010-02-16 15:30:00	MSFT	Stock	28.24	28.37	28.23	28.34	11248306.0
2010-02-16 16:00:00	MSFT	Stock	28.34	28.41	28.241	28.35	3924948.0

> showing 50 of 72,829 rows — these rows as CSV

> unlock the full archive -- $79 one-time