PREVIEW / stock_30min / 2008-05-12

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-12.parquet
  size:    1.2 MB
  rows:    68,939
  symbols: 3,287

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-05-12 06:30:00	AAPL	Stock	6.5611	6.5611	6.5611	6.5611	2800.0
2008-05-12 07:00:00	AAPL	Stock	6.5821	6.595	6.5714	6.595	44800.0
2008-05-12 07:30:00	AAPL	Stock	6.5761	6.5929	6.5679	6.5793	225680.0
2008-05-12 08:00:00	AAPL	Stock	6.5782	6.5996	6.565	6.5911	2356116.0
2008-05-12 08:30:00	AAPL	Stock	6.5911	6.6214	6.5857	6.6139	3060736.0
2008-05-12 09:00:00	AAPL	Stock	6.6139	6.6214	6.5946	6.6132	2746632.0
2008-05-12 09:30:00	AAPL	Stock	6.6132	6.6318	6.5679	6.5932	85753192.0
2008-05-12 10:00:00	AAPL	Stock	6.5929	6.5993	6.5304	6.5943	71945636.0
2008-05-12 10:30:00	AAPL	Stock	6.5954	6.6286	6.58	6.6175	60132296.0
2008-05-12 11:00:00	AAPL	Stock	6.6179	6.6232	6.6018	6.6143	37597588.0
2008-05-12 11:30:00	AAPL	Stock	6.6143	6.6746	6.6082	6.6696	67509568.0
2008-05-12 12:00:00	AAPL	Stock	6.6696	6.695	6.6686	6.6786	62058388.0
2008-05-12 12:30:00	AAPL	Stock	6.6782	6.7064	6.6639	6.6979	50376732.0
2008-05-12 13:00:00	AAPL	Stock	6.6975	6.7071	6.685	6.6882	54429116.0
2008-05-12 13:30:00	AAPL	Stock	6.6871	6.6946	6.6679	6.6932	46777500.0
2008-05-12 14:00:00	AAPL	Stock	6.6936	6.7207	6.6929	6.7179	62588680.0
2008-05-12 14:30:00	AAPL	Stock	6.7175	6.7454	6.7157	6.7371	58977856.0
2008-05-12 15:00:00	AAPL	Stock	6.7361	6.7446	6.7064	6.7064	58224852.0
2008-05-12 15:30:00	AAPL	Stock	6.7064	6.725	6.7014	6.7125	70353500.0
2008-05-12 16:00:00	AAPL	Stock	6.7125	6.7204	6.6636	6.71	9123996.0
2008-05-12 16:30:00	AAPL	Stock	6.7107	6.72	6.6642	6.7146	4363128.0
2008-05-12 17:00:00	AAPL	Stock	6.7143	6.7214	6.7143	6.7171	190988.0
2008-05-12 17:30:00	AAPL	Stock	6.6429	6.7204	6.6429	6.7196	162372.0
2008-05-12 18:00:00	AAPL	Stock	6.7196	6.7229	6.7179	6.7225	242480.0
2008-05-12 18:30:00	AAPL	Stock	6.7221	6.7246	6.7182	6.7182	161812.0
2008-05-12 19:00:00	AAPL	Stock	6.7196	6.7229	6.7182	6.7225	50764.0
2008-05-12 19:30:00	AAPL	Stock	6.7189	6.7304	6.7179	6.7304	282632.0
2008-05-12 08:00:00	MSFT	Stock	29.39	29.47	29.3	29.47	3407.0
2008-05-12 08:30:00	MSFT	Stock	29.45	29.46	29.4	29.46	5875.0
2008-05-12 09:00:00	MSFT	Stock	29.45	29.47	29.17	29.36	89476.0
2008-05-12 09:30:00	MSFT	Stock	29.4	29.57	29.35	29.55	5393404.0
2008-05-12 10:00:00	MSFT	Stock	29.54	29.73	29.52	29.69	5228705.0
2008-05-12 10:30:00	MSFT	Stock	29.69	29.91	29.681	29.91	5956287.0
2008-05-12 11:00:00	MSFT	Stock	29.91	29.96	29.8	29.82	4551461.0
2008-05-12 11:30:00	MSFT	Stock	29.83	29.97	29.82	29.915	2767296.0
2008-05-12 12:00:00	MSFT	Stock	29.91	29.95	29.86	29.92	2152283.0
2008-05-12 12:30:00	MSFT	Stock	29.91	29.93	29.85	29.9	2201114.0
2008-05-12 13:00:00	MSFT	Stock	29.9	29.91	29.76	29.78	3024812.0
2008-05-12 13:30:00	MSFT	Stock	29.78	29.9	29.75	29.77	1796039.0
2008-05-12 14:00:00	MSFT	Stock	29.78	29.93	29.77	29.91	3237539.0
2008-05-12 14:30:00	MSFT	Stock	29.903	30.0	29.86	29.93	5213852.0
2008-05-12 15:00:00	MSFT	Stock	29.93	30.0	29.87	29.982	6874171.0
2008-05-12 15:30:00	MSFT	Stock	29.98	30.06	29.94	29.98	13227050.0
2008-05-12 16:00:00	MSFT	Stock	29.99	30.05	29.852	29.859	1703777.0
2008-05-12 16:30:00	MSFT	Stock	29.99	30.0	29.95	29.99	444793.0
2008-05-12 17:00:00	MSFT	Stock	29.96	29.99	29.3	29.99	96351.0
2008-05-12 17:30:00	MSFT	Stock	29.95	29.97	29.94	29.94	500.0
2008-05-12 18:30:00	MSFT	Stock	29.96	29.96	29.94	29.96	1100.0
2008-05-12 19:00:00	MSFT	Stock	29.95	29.95	29.92	29.92	2915.0
2008-05-12 19:30:00	MSFT	Stock	29.96	29.98	29.92	29.92	2964.0

> showing 50 of 68,939 rows — these rows as CSV

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