PREVIEW / stock_30min / 2012-05-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-14.parquet
  size:    1.4 MB
  rows:    76,492
  symbols: 3,562

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-05-14 04:00:00	AAPL	Stock	20.1071	20.1071	20.0893	20.0893	19600.0
2012-05-14 04:30:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2012-05-14 06:00:00	AAPL	Stock	20.1346	20.1425	20.1196	20.1425	14000.0
2012-05-14 06:30:00	AAPL	Stock	20.1732	20.1732	20.1607	20.1607	5600.0
2012-05-14 07:00:00	AAPL	Stock	20.1261	20.1607	20.0989	20.1496	108444.0
2012-05-14 07:30:00	AAPL	Stock	20.1589	20.1875	20.1532	20.1571	82908.0
2012-05-14 08:00:00	AAPL	Stock	20.1768	20.1779	20.0893	20.1107	870380.0
2012-05-14 08:30:00	AAPL	Stock	20.1107	20.1304	20.0929	20.1246	566552.0
2012-05-14 09:00:00	AAPL	Stock	20.125	20.1721	20.0893	20.0907	1578108.0
2012-05-14 09:30:00	AAPL	Stock	20.0914	20.2682	20.0893	20.1621	60109644.0
2012-05-14 10:00:00	AAPL	Stock	20.163	20.1689	20.0714	20.1039	35368088.0
2012-05-14 10:30:00	AAPL	Stock	20.1016	20.1668	20.0929	20.1158	22937852.0
2012-05-14 11:00:00	AAPL	Stock	20.1171	20.1911	20.0893	20.17	27195476.0
2012-05-14 11:30:00	AAPL	Stock	20.1617	20.1821	20.0939	20.1196	15869056.0
2012-05-14 12:00:00	AAPL	Stock	20.1211	20.1664	20.1089	20.1346	10289216.0
2012-05-14 12:30:00	AAPL	Stock	20.1332	20.1425	20.0979	20.1052	9256016.0
2012-05-14 13:00:00	AAPL	Stock	20.1057	20.1209	20.0275	20.0621	20476148.0
2012-05-14 13:30:00	AAPL	Stock	20.0593	20.1336	20.0457	20.1136	17062164.0
2012-05-14 14:00:00	AAPL	Stock	20.1111	20.1339	20.0657	20.0868	12628952.0
2012-05-14 14:30:00	AAPL	Stock	20.0868	20.0993	20.0293	20.0379	13932324.0
2012-05-14 15:00:00	AAPL	Stock	20.0429	20.0529	19.9929	20.0021	32126164.0
2012-05-14 15:30:00	AAPL	Stock	20.0025	20.0325	19.9143	19.9318	57004276.0
2012-05-14 16:00:00	AAPL	Stock	19.9354	20.0866	19.9229	19.9329	8872640.0
2012-05-14 16:30:00	AAPL	Stock	19.9329	20.0057	19.9282	19.95	373464.0
2012-05-14 17:00:00	AAPL	Stock	19.9464	19.9589	19.9364	19.9429	458500.0
2012-05-14 17:30:00	AAPL	Stock	19.9393	19.955	19.9339	19.9504	165480.0
2012-05-14 18:00:00	AAPL	Stock	19.9536	19.9589	19.9486	19.9571	109116.0
2012-05-14 18:30:00	AAPL	Stock	19.9571	19.9643	19.9564	19.9643	52612.0
2012-05-14 19:00:00	AAPL	Stock	19.9682	19.9764	19.9682	19.9718	52584.0
2012-05-14 19:30:00	AAPL	Stock	19.9782	20.0357	19.9714	20.0357	219968.0
2012-05-14 07:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	300.0
2012-05-14 08:00:00	MSFT	Stock	31.0	31.0	30.91	30.95	6743.0
2012-05-14 08:30:00	MSFT	Stock	30.92	30.92	30.87	30.87	4804.0
2012-05-14 09:00:00	MSFT	Stock	30.91	30.92	30.76	30.76	27124.0
2012-05-14 09:30:00	MSFT	Stock	30.76	30.89	30.7	30.8	3448589.0
2012-05-14 10:00:00	MSFT	Stock	30.81	30.83	30.65	30.69	3257915.0
2012-05-14 10:30:00	MSFT	Stock	30.695	30.796	30.67	30.76	2054020.0
2012-05-14 11:00:00	MSFT	Stock	30.76	30.93	30.715	30.827	2448407.0
2012-05-14 11:30:00	MSFT	Stock	30.82	30.92	30.82	30.91	1457652.0
2012-05-14 12:00:00	MSFT	Stock	30.905	30.98	30.88	30.91	1088507.0
2012-05-14 12:30:00	MSFT	Stock	30.91	30.918	30.79	30.81	1571147.0
2012-05-14 13:00:00	MSFT	Stock	30.82	30.88	30.76	30.807	1581184.0
2012-05-14 13:30:00	MSFT	Stock	30.8	30.99	30.8	30.95	1449898.0
2012-05-14 14:00:00	MSFT	Stock	30.95	31.04	30.88	30.89	1505975.0
2012-05-14 14:30:00	MSFT	Stock	30.89	30.91	30.71	30.727	2540971.0
2012-05-14 15:00:00	MSFT	Stock	30.73	30.82	30.685	30.74	3021806.0
2012-05-14 15:30:00	MSFT	Stock	30.74	30.78	30.64	30.67	8445263.0
2012-05-14 16:00:00	MSFT	Stock	30.67	30.78	30.665	30.68	6179407.0
2012-05-14 16:30:00	MSFT	Stock	30.771	30.771	30.69	30.69	31700.0
2012-05-14 17:00:00	MSFT	Stock	30.7	30.7	30.68	30.68	47785.0

> showing 50 of 76,492 rows — these rows as CSV

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