PREVIEW / stock_30min / 2010-05-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-18.parquet
  size:    1.4 MB
  rows:    77,923
  symbols: 3,478

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-05-18 04:00:00	AAPL	Stock	9.1293	9.1293	9.1293	9.1293	2800.0
2010-05-18 04:30:00	AAPL	Stock	9.1357	9.1357	9.0982	9.1061	30800.0
2010-05-18 05:00:00	AAPL	Stock	9.1075	9.1161	9.1075	9.1161	11284.0
2010-05-18 05:30:00	AAPL	Stock	9.1161	9.1161	9.1071	9.1071	36400.0
2010-05-18 07:00:00	AAPL	Stock	9.1375	9.1482	9.125	9.1318	304472.0
2010-05-18 07:30:00	AAPL	Stock	9.1371	9.1461	9.1346	9.1389	294532.0
2010-05-18 08:00:00	AAPL	Stock	9.1429	9.1496	9.12	9.1279	2089108.0
2010-05-18 08:30:00	AAPL	Stock	9.1343	9.1607	9.1082	9.1571	2981104.0
2010-05-18 09:00:00	AAPL	Stock	9.1557	9.1946	9.1536	9.1771	4453540.0
2010-05-18 09:30:00	AAPL	Stock	9.1775	9.2339	9.1757	9.1868	93232916.0
2010-05-18 10:00:00	AAPL	Stock	9.1868	9.2032	9.1271	9.1364	63931924.0
2010-05-18 10:30:00	AAPL	Stock	9.135	9.1446	8.9996	9.0571	98564312.0
2010-05-18 11:00:00	AAPL	Stock	9.0575	9.1032	9.0332	9.0954	52331300.0
2010-05-18 11:30:00	AAPL	Stock	9.0964	9.0971	9.0107	9.0357	35565348.0
2010-05-18 12:00:00	AAPL	Stock	9.0357	9.0707	9.0039	9.0699	33915336.0
2010-05-18 12:30:00	AAPL	Stock	9.0679	9.1132	9.0589	9.0746	41734616.0
2010-05-18 13:00:00	AAPL	Stock	9.0736	9.0741	9.0107	9.0454	43000832.0
2010-05-18 13:30:00	AAPL	Stock	9.0439	9.0536	8.9804	8.9843	50946980.0
2010-05-18 14:00:00	AAPL	Stock	8.9821	9.0389	8.9768	8.9925	42758520.0
2010-05-18 14:30:00	AAPL	Stock	8.9929	9.0093	8.9379	8.9657	61825232.0
2010-05-18 15:00:00	AAPL	Stock	8.9666	9.0179	8.9425	8.9562	57869420.0
2010-05-18 15:30:00	AAPL	Stock	8.9525	9.0386	8.9507	9.0118	72117388.0
2010-05-18 16:00:00	AAPL	Stock	9.0075	9.1871	9.0029	9.0111	14713748.0
2010-05-18 16:30:00	AAPL	Stock	9.0111	9.0154	8.9546	9.0064	872424.0
2010-05-18 17:00:00	AAPL	Stock	9.0064	9.0732	8.975	8.975	755216.0
2010-05-18 17:30:00	AAPL	Stock	8.9779	8.9821	8.9732	8.975	258132.0
2010-05-18 18:00:00	AAPL	Stock	8.9743	9.0129	8.9579	8.9604	312172.0
2010-05-18 18:30:00	AAPL	Stock	8.9604	8.9607	8.9429	8.9429	386428.0
2010-05-18 19:00:00	AAPL	Stock	8.9429	8.9536	8.9382	8.9471	414064.0
2010-05-18 19:30:00	AAPL	Stock	8.9496	8.9496	8.9179	8.9286	687260.0
2010-05-18 08:00:00	MSFT	Stock	29.0	29.04	28.86	28.86	4000.0
2010-05-18 08:30:00	MSFT	Stock	28.99	29.09	28.99	29.09	4868.0
2010-05-18 09:00:00	MSFT	Stock	29.03	29.05	28.87	28.87	43383.0
2010-05-18 09:30:00	MSFT	Stock	28.91	29.0	28.76	28.89	3381455.0
2010-05-18 10:00:00	MSFT	Stock	28.88	28.93	28.75	28.75	2717233.0
2010-05-18 10:30:00	MSFT	Stock	28.755	28.913	28.47	28.51	5049095.0
2010-05-18 11:00:00	MSFT	Stock	28.51	28.75	28.48	28.75	4706790.0
2010-05-18 11:30:00	MSFT	Stock	28.75	28.77	28.55	28.61	2803575.0
2010-05-18 12:00:00	MSFT	Stock	28.61	28.7	28.53	28.617	2789034.0
2010-05-18 12:30:00	MSFT	Stock	28.61	28.72	28.57	28.64	3029596.0
2010-05-18 13:00:00	MSFT	Stock	28.63	28.67	28.47	28.553	4108562.0
2010-05-18 13:30:00	MSFT	Stock	28.56	28.6	28.45	28.49	3064772.0
2010-05-18 14:00:00	MSFT	Stock	28.49	28.65	28.47	28.56	3059494.0
2010-05-18 14:30:00	MSFT	Stock	28.57	28.57	28.4	28.492	2904971.0
2010-05-18 15:00:00	MSFT	Stock	28.49	28.66	28.4	28.47	3987148.0
2010-05-18 15:30:00	MSFT	Stock	28.47	28.66	28.44	28.62	7402909.0
2010-05-18 16:00:00	MSFT	Stock	28.62	28.797	28.555	28.63	2526095.0
2010-05-18 16:30:00	MSFT	Stock	28.614	28.63	28.467	28.62	118247.0
2010-05-18 17:00:00	MSFT	Stock	28.62	28.62	28.5	28.5	16181.0
2010-05-18 17:30:00	MSFT	Stock	28.47	28.47	28.47	28.47	300.0

> showing 50 of 77,923 rows — these rows as CSV

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