PREVIEW / stock_30min / 2008-03-28

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-28.parquet
  size:    1.2 MB
  rows:    67,321
  symbols: 3,280

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
2008-03-28 04:00:00	AAPL	Stock	5.0393	5.0393	5.0393	5.0393	5600.0
2008-03-28 04:30:00	AAPL	Stock	5.0393	5.0393	5.0393	5.0393	5600.0
2008-03-28 05:00:00	AAPL	Stock	5.0761	5.0761	5.0761	5.0761	14000.0
2008-03-28 06:00:00	AAPL	Stock	5.0818	5.0818	5.0714	5.0714	19600.0
2008-03-28 06:30:00	AAPL	Stock	5.0714	5.0714	5.0393	5.0411	94360.0
2008-03-28 07:00:00	AAPL	Stock	5.08	5.08	5.0711	5.075	163240.0
2008-03-28 07:30:00	AAPL	Stock	5.0893	5.0964	5.0607	5.0807	150500.0
2008-03-28 08:00:00	AAPL	Stock	5.0821	5.0871	5.0643	5.0679	1332044.0
2008-03-28 08:30:00	AAPL	Stock	5.0718	5.0893	5.0614	5.0668	3090444.0
2008-03-28 09:00:00	AAPL	Stock	5.0661	5.0661	5.0482	5.0639	2672292.0
2008-03-28 09:30:00	AAPL	Stock	5.0643	5.125	5.0571	5.1157	131912676.0
2008-03-28 10:00:00	AAPL	Stock	5.1154	5.1421	5.1089	5.1246	77751884.0
2008-03-28 10:30:00	AAPL	Stock	5.1243	5.1375	5.0989	5.1136	59865036.0
2008-03-28 11:00:00	AAPL	Stock	5.1136	5.1429	5.1082	5.135	53671324.0
2008-03-28 11:30:00	AAPL	Stock	5.135	5.1661	5.135	5.1565	49844704.0
2008-03-28 12:00:00	AAPL	Stock	5.1561	5.1586	5.1346	5.1489	30405704.0
2008-03-28 12:30:00	AAPL	Stock	5.1496	5.1561	5.1279	5.1389	35889952.0
2008-03-28 13:00:00	AAPL	Stock	5.1386	5.1532	5.1357	5.1457	26130244.0
2008-03-28 13:30:00	AAPL	Stock	5.1456	5.1475	5.1179	5.1296	37527896.0
2008-03-28 14:00:00	AAPL	Stock	5.1296	5.1411	5.1096	5.1118	35838740.0
2008-03-28 14:30:00	AAPL	Stock	5.1118	5.1293	5.1004	5.1293	36789648.0
2008-03-28 15:00:00	AAPL	Stock	5.1289	5.1318	5.0911	5.1086	48474132.0
2008-03-28 15:30:00	AAPL	Stock	5.1089	5.1143	5.0793	5.1079	60371080.0
2008-03-28 16:00:00	AAPL	Stock	5.1036	5.1234	5.1004	5.1129	11608968.0
2008-03-28 16:30:00	AAPL	Stock	5.1129	5.1246	5.1075	5.1164	421708.0
2008-03-28 17:00:00	AAPL	Stock	5.1168	5.1186	5.1125	5.1171	430108.0
2008-03-28 17:30:00	AAPL	Stock	5.1075	5.1182	5.1071	5.1121	556724.0
2008-03-28 18:00:00	AAPL	Stock	5.1125	5.1179	5.1107	5.1125	214956.0
2008-03-28 18:30:00	AAPL	Stock	5.1161	5.1214	5.1075	5.1179	140700.0
2008-03-28 19:00:00	AAPL	Stock	5.1171	5.1225	5.115	5.12	114128.0
2008-03-28 19:30:00	AAPL	Stock	5.1193	5.1236	5.1168	5.1196	380968.0
2008-03-28 06:30:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2008-03-28 07:00:00	MSFT	Stock	28.37	28.37	28.37	28.37	800.0
2008-03-28 07:30:00	MSFT	Stock	28.27	28.27	28.27	28.27	200.0
2008-03-28 08:00:00	MSFT	Stock	28.28	28.28	28.05	28.23	518330.0
2008-03-28 08:30:00	MSFT	Stock	28.23	28.24	28.2	28.2	10000.0
2008-03-28 09:00:00	MSFT	Stock	28.2	28.25	28.2	28.23	13400.0
2008-03-28 09:30:00	MSFT	Stock	28.24	28.43	28.12	28.36	4769638.0
2008-03-28 10:00:00	MSFT	Stock	28.37	28.42	28.22	28.32	4222321.0
2008-03-28 10:30:00	MSFT	Stock	28.32	28.34	28.22	28.28	2703812.0
2008-03-28 11:00:00	MSFT	Stock	28.28	28.34	28.25	28.31	2149679.0
2008-03-28 11:30:00	MSFT	Stock	28.301	28.38	28.29	28.34	1920203.0
2008-03-28 12:00:00	MSFT	Stock	28.34	28.39	28.32	28.39	1414542.0
2008-03-28 12:30:00	MSFT	Stock	28.39	28.39	28.26	28.32	1152600.0
2008-03-28 13:00:00	MSFT	Stock	28.32	28.33	28.26	28.32	1151897.0
2008-03-28 13:30:00	MSFT	Stock	28.311	28.32	28.16	28.19	2762178.0
2008-03-28 14:00:00	MSFT	Stock	28.18	28.2	28.14	28.15	2515427.0
2008-03-28 14:30:00	MSFT	Stock	28.16	28.185	27.83	27.98	5437520.0
2008-03-28 15:00:00	MSFT	Stock	27.98	28.02	27.85	27.992	4153812.0
2008-03-28 15:30:00	MSFT	Stock	28.0	28.0	27.88	27.9	5564011.0

> showing 50 of 67,321 rows — these rows as CSV

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