PREVIEW / stock_30min / 2008-10-31

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-31.parquet
  size:    1.3 MB
  rows:    73,254
  symbols: 3,358

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-10-31 04:00:00	AAPL	Stock	3.9386	3.9386	3.9121	3.9121	8400.0
2008-10-31 04:30:00	AAPL	Stock	3.8596	3.9196	3.8596	3.9196	57960.0
2008-10-31 06:30:00	AAPL	Stock	3.8929	3.8929	3.8929	3.8929	28000.0
2008-10-31 07:30:00	AAPL	Stock	3.9532	3.9532	3.9107	3.9179	106820.0
2008-10-31 08:00:00	AAPL	Stock	3.9243	3.9354	3.8968	3.9232	1782508.0
2008-10-31 08:30:00	AAPL	Stock	3.9186	3.9396	3.9154	3.9286	2611840.0
2008-10-31 09:00:00	AAPL	Stock	3.9339	3.9375	3.8079	3.8368	18670288.0
2008-10-31 09:30:00	AAPL	Stock	3.8318	3.8464	3.755	3.7882	237452376.0
2008-10-31 10:00:00	AAPL	Stock	3.7875	3.8571	3.7679	3.8189	175493360.0
2008-10-31 10:30:00	AAPL	Stock	3.8193	3.8393	3.7979	3.8175	96622904.0
2008-10-31 11:00:00	AAPL	Stock	3.8175	3.8607	3.7979	3.8393	126892388.0
2008-10-31 11:30:00	AAPL	Stock	3.8393	3.8882	3.8357	3.8732	96002984.0
2008-10-31 12:00:00	AAPL	Stock	3.8725	3.8757	3.8332	3.8579	76618360.0
2008-10-31 12:30:00	AAPL	Stock	3.8586	3.8775	3.8464	3.8668	46420500.0
2008-10-31 13:00:00	AAPL	Stock	3.8661	3.9171	3.8593	3.9036	83743856.0
2008-10-31 13:30:00	AAPL	Stock	3.9032	3.925	3.8571	3.8986	82342904.0
2008-10-31 14:00:00	AAPL	Stock	3.8989	3.9107	3.8454	3.8786	100402708.0
2008-10-31 14:30:00	AAPL	Stock	3.8789	3.9482	3.8571	3.9379	126357784.0
2008-10-31 15:00:00	AAPL	Stock	3.9379	3.9564	3.8696	3.8779	153790224.0
2008-10-31 15:30:00	AAPL	Stock	3.8775	3.9143	3.8107	3.8514	170340240.0
2008-10-31 16:00:00	AAPL	Stock	3.8554	3.8849	3.8357	3.8479	32566380.0
2008-10-31 16:30:00	AAPL	Stock	3.8425	3.8554	3.8394	3.8529	1684508.0
2008-10-31 17:00:00	AAPL	Stock	3.8529	3.8589	3.8386	3.8518	5624556.0
2008-10-31 17:30:00	AAPL	Stock	3.8425	3.8589	3.8425	3.8571	1097096.0
2008-10-31 18:00:00	AAPL	Stock	3.8571	3.8571	3.855	3.8571	153860.0
2008-10-31 18:30:00	AAPL	Stock	3.8589	3.8604	3.8536	3.8543	133280.0
2008-10-31 19:00:00	AAPL	Stock	3.8543	3.8589	3.8536	3.8536	47068.0
2008-10-31 19:30:00	AAPL	Stock	3.8571	3.8607	3.8571	3.8607	121436.0
2008-10-31 08:00:00	MSFT	Stock	22.5	22.79	22.41	22.52	21145.0
2008-10-31 08:30:00	MSFT	Stock	22.54	22.64	22.48	22.59	12369.0
2008-10-31 09:00:00	MSFT	Stock	22.63	22.64	22.4	22.54	110790.0
2008-10-31 09:30:00	MSFT	Stock	22.53	22.78	22.12	22.25	9603582.0
2008-10-31 10:00:00	MSFT	Stock	22.25	22.54	22.23	22.34	6805443.0
2008-10-31 10:30:00	MSFT	Stock	22.342	22.45	22.23	22.36	3451511.0
2008-10-31 11:00:00	MSFT	Stock	22.36	22.51	22.32	22.418	5217311.0
2008-10-31 11:30:00	MSFT	Stock	22.42	22.5	22.2	22.327	6199812.0
2008-10-31 12:00:00	MSFT	Stock	22.33	22.42	22.25	22.32	3671201.0
2008-10-31 12:30:00	MSFT	Stock	22.32	22.47	22.25	22.411	3608557.0
2008-10-31 13:00:00	MSFT	Stock	22.411	22.79	22.39	22.74	3670522.0
2008-10-31 13:30:00	MSFT	Stock	22.74	22.91	22.63	22.699	4607003.0
2008-10-31 14:00:00	MSFT	Stock	22.69	22.84	22.53	22.67	4232550.0
2008-10-31 14:30:00	MSFT	Stock	22.68	22.85	22.58	22.735	5132860.0
2008-10-31 15:00:00	MSFT	Stock	22.74	22.91	22.44	22.47	7829136.0
2008-10-31 15:30:00	MSFT	Stock	22.46	22.66	22.21	22.41	14109389.0
2008-10-31 16:00:00	MSFT	Stock	22.41	22.592	22.33	22.33	11651010.0
2008-10-31 16:30:00	MSFT	Stock	22.33	22.45	22.325	22.42	443115.0
2008-10-31 17:00:00	MSFT	Stock	22.45	22.47	22.33	22.33	723810.0
2008-10-31 17:30:00	MSFT	Stock	22.49	22.59	22.33	22.47	307137.0
2008-10-31 18:00:00	MSFT	Stock	22.47	22.47	22.44	22.46	4599.0
2008-10-31 18:30:00	MSFT	Stock	22.48	22.48	22.46	22.46	1125.0

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

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