PREVIEW / stock_30min / 2012-01-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-23.parquet
  size:    1.4 MB
  rows:    73,880
  symbols: 3,538

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
2012-01-23 04:00:00	AAPL	Stock	15.0786	15.0786	15.0786	15.0786	2800.0
2012-01-23 04:30:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	14000.0
2012-01-23 05:00:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	8400.0
2012-01-23 05:30:00	AAPL	Stock	15.0982	15.1214	15.0982	15.1214	11200.0
2012-01-23 06:00:00	AAPL	Stock	15.1429	15.1429	15.1429	15.1429	37268.0
2012-01-23 06:30:00	AAPL	Stock	15.1429	15.1736	15.1429	15.1464	61600.0
2012-01-23 07:00:00	AAPL	Stock	15.1411	15.1582	15.0893	15.1057	274764.0
2012-01-23 07:30:00	AAPL	Stock	15.1071	15.1264	15.09	15.1107	189616.0
2012-01-23 08:00:00	AAPL	Stock	15.1186	15.1621	15.1171	15.1368	1143184.0
2012-01-23 08:30:00	AAPL	Stock	15.1343	15.1357	15.095	15.095	651084.0
2012-01-23 09:00:00	AAPL	Stock	15.0964	15.1193	15.0107	15.0964	7219408.0
2012-01-23 09:30:00	AAPL	Stock	15.0964	15.2732	15.0821	15.2368	63225204.0
2012-01-23 10:00:00	AAPL	Stock	15.2368	15.3018	15.2343	15.235	31785320.0
2012-01-23 10:30:00	AAPL	Stock	15.2343	15.2704	15.2286	15.2704	20369664.0
2012-01-23 11:00:00	AAPL	Stock	15.2714	15.2796	15.2143	15.2368	22528912.0
2012-01-23 11:30:00	AAPL	Stock	15.2339	15.2421	15.1936	15.1957	17235316.0
2012-01-23 12:00:00	AAPL	Stock	15.195	15.2021	15.1654	15.2014	19545764.0
2012-01-23 12:30:00	AAPL	Stock	15.2014	15.2054	15.1914	15.1982	8841840.0
2012-01-23 13:00:00	AAPL	Stock	15.1991	15.2439	15.1979	15.2432	11404428.0
2012-01-23 13:30:00	AAPL	Stock	15.2432	15.2675	15.23	15.2639	12136488.0
2012-01-23 14:00:00	AAPL	Stock	15.2636	15.2657	15.2296	15.2368	11753168.0
2012-01-23 14:30:00	AAPL	Stock	15.2371	15.2389	15.2075	15.2154	16085692.0
2012-01-23 15:00:00	AAPL	Stock	15.215	15.2411	15.21	15.2364	14761796.0
2012-01-23 15:30:00	AAPL	Stock	15.2364	15.2711	15.2357	15.2629	31301508.0
2012-01-23 16:00:00	AAPL	Stock	15.265	15.2711	15.2257	15.2671	8684956.0
2012-01-23 16:30:00	AAPL	Stock	15.265	15.2679	15.2261	15.265	786968.0
2012-01-23 17:00:00	AAPL	Stock	15.2675	15.2746	15.2636	15.2746	158144.0
2012-01-23 17:30:00	AAPL	Stock	15.2746	15.2829	15.2714	15.2729	95508.0
2012-01-23 18:00:00	AAPL	Stock	15.2729	15.275	15.1968	15.2179	712292.0
2012-01-23 18:30:00	AAPL	Stock	15.2179	15.2264	15.2161	15.2264	171052.0
2012-01-23 19:00:00	AAPL	Stock	15.2236	15.2268	15.2161	15.2225	144704.0
2012-01-23 19:30:00	AAPL	Stock	15.225	15.225	15.2146	15.2214	267064.0
2012-01-23 04:00:00	MSFT	Stock	29.64	29.64	29.64	29.64	500.0
2012-01-23 04:30:00	MSFT	Stock	29.64	29.64	29.6	29.6	3100.0
2012-01-23 05:30:00	MSFT	Stock	29.59	29.65	29.59	29.65	1900.0
2012-01-23 06:00:00	MSFT	Stock	29.68	29.68	29.68	29.68	1500.0
2012-01-23 07:00:00	MSFT	Stock	29.65	29.7	29.63	29.7	7800.0
2012-01-23 07:30:00	MSFT	Stock	29.7	29.7	29.7	29.7	800.0
2012-01-23 08:00:00	MSFT	Stock	29.7	29.73	29.58	29.65	62478.0
2012-01-23 08:30:00	MSFT	Stock	29.65	29.72	29.65	29.7	36830.0
2012-01-23 09:00:00	MSFT	Stock	29.7	29.72	29.49	29.54	1853253.0
2012-01-23 09:30:00	MSFT	Stock	29.53	29.93	29.51	29.92	14840783.0
2012-01-23 10:00:00	MSFT	Stock	29.93	29.95	29.66	29.665	9404127.0
2012-01-23 10:30:00	MSFT	Stock	29.664	29.8	29.66	29.73	7663557.0
2012-01-23 11:00:00	MSFT	Stock	29.74	29.75	29.54	29.67	6781921.0
2012-01-23 11:30:00	MSFT	Stock	29.675	29.7	29.57	29.61	3993892.0
2012-01-23 12:00:00	MSFT	Stock	29.6	29.615	29.35	29.5	3889065.0
2012-01-23 12:30:00	MSFT	Stock	29.509	29.52	29.41	29.431	2462703.0
2012-01-23 13:00:00	MSFT	Stock	29.437	29.525	29.43	29.52	2765243.0
2012-01-23 13:30:00	MSFT	Stock	29.53	29.635	29.5	29.629	2301542.0

> showing 50 of 73,880 rows — these rows as CSV

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