PREVIEW / stock_30min / 2008-03-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-18.parquet
  size:    1.2 MB
  rows:    70,168
  symbols: 3,295

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-18 06:00:00	AAPL	Stock	4.5921	4.6064	4.5921	4.6064	61488.0
2008-03-18 06:30:00	AAPL	Stock	4.5893	4.6054	4.5861	4.6054	101948.0
2008-03-18 07:00:00	AAPL	Stock	4.5975	4.5982	4.5893	4.59	42140.0
2008-03-18 07:30:00	AAPL	Stock	4.5971	4.6082	4.5929	4.6054	511812.0
2008-03-18 08:00:00	AAPL	Stock	4.6039	4.6136	4.5893	4.6	4368364.0
2008-03-18 08:30:00	AAPL	Stock	4.5968	4.6071	4.5911	4.5946	1576148.0
2008-03-18 09:00:00	AAPL	Stock	4.5979	4.6196	4.5979	4.6157	5321428.0
2008-03-18 09:30:00	AAPL	Stock	4.6136	4.6564	4.5954	4.6296	159997684.0
2008-03-18 10:00:00	AAPL	Stock	4.6296	4.6443	4.6004	4.6164	74705512.0
2008-03-18 10:30:00	AAPL	Stock	4.6165	4.645	4.61	4.6214	59837092.0
2008-03-18 11:00:00	AAPL	Stock	4.6207	4.6411	4.6161	4.6304	53875108.0
2008-03-18 11:30:00	AAPL	Stock	4.6304	4.6554	4.6225	4.625	56292936.0
2008-03-18 12:00:00	AAPL	Stock	4.6247	4.6521	4.6182	4.6496	41250972.0
2008-03-18 12:30:00	AAPL	Stock	4.6496	4.6782	4.6432	4.6671	63496860.0
2008-03-18 13:00:00	AAPL	Stock	4.6675	4.6961	4.6671	4.6779	59196368.0
2008-03-18 13:30:00	AAPL	Stock	4.6765	4.6943	4.6739	4.6821	46065432.0
2008-03-18 14:00:00	AAPL	Stock	4.6831	4.6904	4.625	4.6375	148418452.0
2008-03-18 14:30:00	AAPL	Stock	4.6368	4.7293	4.61	4.7221	160568520.0
2008-03-18 15:00:00	AAPL	Stock	4.7225	4.7314	4.6875	4.7132	105526064.0
2008-03-18 15:30:00	AAPL	Stock	4.7115	4.75	4.7054	4.7482	125611612.0
2008-03-18 16:00:00	AAPL	Stock	4.7474	4.75	4.6539	4.7375	19505052.0
2008-03-18 16:30:00	AAPL	Stock	4.7432	4.75	4.7357	4.7375	446068.0
2008-03-18 17:00:00	AAPL	Stock	4.74	4.7436	4.6778	4.7382	1114120.0
2008-03-18 17:30:00	AAPL	Stock	4.7386	4.7407	4.6221	4.7364	802116.0
2008-03-18 18:00:00	AAPL	Stock	4.74	4.75	4.7368	4.7468	917980.0
2008-03-18 18:30:00	AAPL	Stock	4.7482	4.7611	4.7482	4.755	267232.0
2008-03-18 19:00:00	AAPL	Stock	4.7536	4.7554	4.75	4.7507	79184.0
2008-03-18 19:30:00	AAPL	Stock	4.75	4.7557	4.7496	4.7518	191156.0
2008-03-18 06:30:00	MSFT	Stock	28.7	28.7	28.7	28.7	100.0
2008-03-18 08:00:00	MSFT	Stock	28.72	28.72	28.3	28.65	536885.0
2008-03-18 08:30:00	MSFT	Stock	28.65	28.75	28.3	28.75	465864.0
2008-03-18 09:00:00	MSFT	Stock	28.75	28.75	28.63	28.73	37348.0
2008-03-18 09:30:00	MSFT	Stock	28.7	29.1	28.67	28.94	8141960.0
2008-03-18 10:00:00	MSFT	Stock	28.94	29.06	28.9	28.98	5269664.0
2008-03-18 10:30:00	MSFT	Stock	28.99	29.137	28.92	29.02	4492771.0
2008-03-18 11:00:00	MSFT	Stock	29.03	29.07	28.86	28.915	4737878.0
2008-03-18 11:30:00	MSFT	Stock	28.92	28.92	28.82	28.83	3342839.0
2008-03-18 12:00:00	MSFT	Stock	28.83	28.97	28.79	28.97	2884139.0
2008-03-18 12:30:00	MSFT	Stock	28.97	29.17	28.96	29.16	4408430.0
2008-03-18 13:00:00	MSFT	Stock	29.16	29.17	29.02	29.03	2648572.0
2008-03-18 13:30:00	MSFT	Stock	29.03	29.23	29.03	29.19	3572718.0
2008-03-18 14:00:00	MSFT	Stock	29.192	29.22	28.71	28.88	13181262.0
2008-03-18 14:30:00	MSFT	Stock	28.88	29.31	28.68	29.29	9063241.0
2008-03-18 15:00:00	MSFT	Stock	29.28	29.29	29.15	29.21	5297060.0
2008-03-18 15:30:00	MSFT	Stock	29.2	29.47	29.18	29.46	9305026.0
2008-03-18 16:00:00	MSFT	Stock	29.449	29.48	29.046	29.45	4121286.0
2008-03-18 16:30:00	MSFT	Stock	29.45	29.48	29.097	29.43	76075.0
2008-03-18 17:00:00	MSFT	Stock	29.41	29.45	29.032	29.45	16849.0
2008-03-18 17:30:00	MSFT	Stock	29.42	29.42	28.969	29.3	3300.0
2008-03-18 18:00:00	MSFT	Stock	29.4	29.4	29.18	29.31	878.0

> showing 50 of 70,168 rows — these rows as CSV

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