PREVIEW / stock_30min / 2008-04-22

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-22.parquet
  size:    1.2 MB
  rows:    69,446
  symbols: 3,279

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-04-22 05:00:00	AAPL	Stock	5.9857	5.9857	5.9857	5.9857	2800.0
2008-04-22 05:30:00	AAPL	Stock	5.9789	6.0129	5.9789	6.0129	8400.0
2008-04-22 06:00:00	AAPL	Stock	6.0125	6.0179	6.0125	6.0179	8400.0
2008-04-22 06:30:00	AAPL	Stock	6.0071	6.0071	6.0	6.0	64708.0
2008-04-22 07:00:00	AAPL	Stock	5.9993	6.0007	5.9918	5.9918	157920.0
2008-04-22 07:30:00	AAPL	Stock	5.9964	6.0036	5.9893	5.9893	147700.0
2008-04-22 08:00:00	AAPL	Stock	5.9893	6.0129	5.9732	5.9946	4015984.0
2008-04-22 08:30:00	AAPL	Stock	5.9946	5.9946	5.9468	5.9671	4480980.0
2008-04-22 09:00:00	AAPL	Stock	5.9671	5.9821	5.9571	5.9789	4433212.0
2008-04-22 09:30:00	AAPL	Stock	5.9789	6.0	5.8868	5.9062	172053028.0
2008-04-22 10:00:00	AAPL	Stock	5.9046	5.9082	5.83	5.83	158432120.0
2008-04-22 10:30:00	AAPL	Stock	5.83	5.8561	5.76	5.7968	150183404.0
2008-04-22 11:00:00	AAPL	Stock	5.7968	5.8136	5.7804	5.7971	75672212.0
2008-04-22 11:30:00	AAPL	Stock	5.7968	5.7971	5.7446	5.7611	78142932.0
2008-04-22 12:00:00	AAPL	Stock	5.7604	5.7632	5.7011	5.7046	105531244.0
2008-04-22 12:30:00	AAPL	Stock	5.7036	5.704	5.6461	5.6786	119173712.0
2008-04-22 13:00:00	AAPL	Stock	5.6786	5.7171	5.6711	5.7143	87482416.0
2008-04-22 13:30:00	AAPL	Stock	5.7143	5.7311	5.6879	5.7175	71155224.0
2008-04-22 14:00:00	AAPL	Stock	5.7179	5.7604	5.7093	5.7536	87607380.0
2008-04-22 14:30:00	AAPL	Stock	5.7539	5.7679	5.7196	5.7339	81575256.0
2008-04-22 15:00:00	AAPL	Stock	5.7339	5.7621	5.7196	5.7354	72263856.0
2008-04-22 15:30:00	AAPL	Stock	5.7354	5.755	5.7143	5.7214	110840772.0
2008-04-22 16:00:00	AAPL	Stock	5.7275	5.7804	5.7211	5.7411	11781812.0
2008-04-22 16:30:00	AAPL	Stock	5.7425	5.7446	5.7214	5.7446	2067548.0
2008-04-22 17:00:00	AAPL	Stock	5.7446	5.7846	5.7429	5.7739	3330292.0
2008-04-22 17:30:00	AAPL	Stock	5.775	5.7993	5.775	5.7975	2710876.0
2008-04-22 18:00:00	AAPL	Stock	5.7982	5.8	5.7214	5.7857	997892.0
2008-04-22 18:30:00	AAPL	Stock	5.7843	5.7936	5.7775	5.7786	977312.0
2008-04-22 19:00:00	AAPL	Stock	5.7818	5.7893	5.7779	5.7861	632436.0
2008-04-22 19:30:00	AAPL	Stock	5.7861	5.7875	5.7786	5.7843	437080.0
2008-04-22 07:00:00	MSFT	Stock	30.53	30.53	30.53	30.53	200.0
2008-04-22 07:30:00	MSFT	Stock	30.59	30.6	30.56	30.59	5930.0
2008-04-22 08:00:00	MSFT	Stock	30.53	30.61	30.42	30.55	33917.0
2008-04-22 08:30:00	MSFT	Stock	30.55	30.59	30.19	30.46	13730.0
2008-04-22 09:00:00	MSFT	Stock	30.46	30.64	30.37	30.63	337705.0
2008-04-22 09:30:00	MSFT	Stock	30.64	30.64	30.37	30.46	6378588.0
2008-04-22 10:00:00	MSFT	Stock	30.46	30.7	30.46	30.6	7611713.0
2008-04-22 10:30:00	MSFT	Stock	30.6	30.65	30.5	30.59	4866649.0
2008-04-22 11:00:00	MSFT	Stock	30.59	30.64	30.45	30.61	6698412.0
2008-04-22 11:30:00	MSFT	Stock	30.61	30.61	30.2	30.23	6292352.0
2008-04-22 12:00:00	MSFT	Stock	30.24	30.24	29.97	30.08	5599427.0
2008-04-22 12:30:00	MSFT	Stock	30.08	30.14	30.07	30.08	2509716.0
2008-04-22 13:00:00	MSFT	Stock	30.08	30.15	29.98	30.07	3857115.0
2008-04-22 13:30:00	MSFT	Stock	30.07	30.14	30.01	30.06	4010255.0
2008-04-22 14:00:00	MSFT	Stock	30.05	30.15	30.0	30.12	3761371.0
2008-04-22 14:30:00	MSFT	Stock	30.12	30.17	30.01	30.03	3253202.0
2008-04-22 15:00:00	MSFT	Stock	30.03	30.2	30.02	30.198	3412172.0
2008-04-22 15:30:00	MSFT	Stock	30.2	30.28	30.18	30.27	5442150.0
2008-04-22 16:00:00	MSFT	Stock	30.28	30.33	30.127	30.22	1870068.0
2008-04-22 16:30:00	MSFT	Stock	30.22	30.42	30.21	30.3	158051.0

> showing 50 of 69,446 rows — these rows as CSV

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