PREVIEW / stock_30min / 2009-02-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-02.parquet
  size:    1.2 MB
  rows:    68,836
  symbols: 3,294

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
2009-02-02 07:00:00	AAPL	Stock	3.1932	3.1932	3.1786	3.1786	11200.0
2009-02-02 07:30:00	AAPL	Stock	3.1607	3.1607	3.1607	3.1607	2800.0
2009-02-02 08:00:00	AAPL	Stock	3.1768	3.1961	3.1704	3.1714	339220.0
2009-02-02 08:30:00	AAPL	Stock	3.1714	3.1804	3.1704	3.1771	327544.0
2009-02-02 09:00:00	AAPL	Stock	3.1796	3.2189	3.1786	3.1825	1021412.0
2009-02-02 09:30:00	AAPL	Stock	3.1821	3.2443	3.175	3.2339	75469856.0
2009-02-02 10:00:00	AAPL	Stock	3.2325	3.2729	3.2289	3.2624	61342904.0
2009-02-02 10:30:00	AAPL	Stock	3.2618	3.2639	3.2325	3.2332	35488096.0
2009-02-02 11:00:00	AAPL	Stock	3.2336	3.2454	3.2239	3.2375	32392612.0
2009-02-02 11:30:00	AAPL	Stock	3.2377	3.2539	3.2304	3.2443	24637088.0
2009-02-02 12:00:00	AAPL	Stock	3.2443	3.2593	3.2414	3.2525	24380664.0
2009-02-02 12:30:00	AAPL	Stock	3.2525	3.2686	3.2443	3.2636	30311120.0
2009-02-02 13:00:00	AAPL	Stock	3.2639	3.2646	3.2368	3.2411	25584944.0
2009-02-02 13:30:00	AAPL	Stock	3.2418	3.2564	3.2304	3.2361	23486344.0
2009-02-02 14:00:00	AAPL	Stock	3.2358	3.2407	3.2068	3.2193	30876132.0
2009-02-02 14:30:00	AAPL	Stock	3.2193	3.2318	3.2093	3.225	27541808.0
2009-02-02 15:00:00	AAPL	Stock	3.2246	3.2549	3.2182	3.2521	43004500.0
2009-02-02 15:30:00	AAPL	Stock	3.2521	3.2857	3.2521	3.2689	97169828.0
2009-02-02 16:00:00	AAPL	Stock	3.2689	3.2768	3.2321	3.2682	17236268.0
2009-02-02 16:30:00	AAPL	Stock	3.2686	3.2714	3.2454	3.2679	1097096.0
2009-02-02 17:00:00	AAPL	Stock	3.2189	3.2696	3.2189	3.2686	1056664.0
2009-02-02 17:30:00	AAPL	Stock	3.2664	3.2682	3.2625	3.2625	174776.0
2009-02-02 18:00:00	AAPL	Stock	3.2582	3.2682	3.2571	3.2571	174888.0
2009-02-02 18:30:00	AAPL	Stock	3.2571	3.2571	3.2571	3.2571	19600.0
2009-02-02 19:00:00	AAPL	Stock	3.2536	3.2607	3.2536	3.2607	95564.0
2009-02-02 19:30:00	AAPL	Stock	3.2629	3.2671	3.2625	3.2625	48300.0
2009-02-02 04:00:00	MSFT	Stock	17.0	17.0	17.0	17.0	100.0
2009-02-02 08:00:00	MSFT	Stock	17.03	17.1	17.0	17.03	15886.0
2009-02-02 08:30:00	MSFT	Stock	17.03	17.03	16.95	16.99	32339.0
2009-02-02 09:00:00	MSFT	Stock	17.0	17.04	16.97	17.04	382937.0
2009-02-02 09:30:00	MSFT	Stock	17.03	17.595	17.0	17.58	9880316.0
2009-02-02 10:00:00	MSFT	Stock	17.58	17.9	17.57	17.75	10766055.0
2009-02-02 10:30:00	MSFT	Stock	17.75	17.84	17.66	17.812	4886324.0
2009-02-02 11:00:00	MSFT	Stock	17.812	17.92	17.72	17.92	5036335.0
2009-02-02 11:30:00	MSFT	Stock	17.91	18.05	17.89	17.91	7226203.0
2009-02-02 12:00:00	MSFT	Stock	17.91	18.02	17.87	17.89	5476544.0
2009-02-02 12:30:00	MSFT	Stock	17.89	18.12	17.89	18.09	6803277.0
2009-02-02 13:00:00	MSFT	Stock	18.098	18.13	18.02	18.025	6146552.0
2009-02-02 13:30:00	MSFT	Stock	18.03	18.05	17.87	17.88	3026259.0
2009-02-02 14:00:00	MSFT	Stock	17.875	17.89	17.72	17.78	5371876.0
2009-02-02 14:30:00	MSFT	Stock	17.79	17.85	17.75	17.768	3094041.0
2009-02-02 15:00:00	MSFT	Stock	17.76	17.97	17.74	17.9	5360385.0
2009-02-02 15:30:00	MSFT	Stock	17.89	18.07	17.85	17.86	11769037.0
2009-02-02 16:00:00	MSFT	Stock	17.86	17.957	17.71	17.83	1851771.0
2009-02-02 16:30:00	MSFT	Stock	17.83	17.87	17.83	17.85	263983.0
2009-02-02 17:00:00	MSFT	Stock	17.1	17.1	17.1	17.1	319182.0
2009-02-02 17:30:00	MSFT	Stock	17.84	17.89	17.1	17.89	32477.0
2009-02-02 18:00:00	MSFT	Stock	17.84	17.84	17.83	17.83	2000.0
2009-02-02 18:30:00	MSFT	Stock	17.83	17.83	17.82	17.82	6165.0
2009-02-02 19:00:00	MSFT	Stock	17.82	17.82	17.82	17.82	2700.0

> showing 50 of 68,836 rows — these rows as CSV

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