PREVIEW / etf_30min / 2008-02-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-29.parquet
  size:    160 KB
  rows:    5,781

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-02-29 04:30:00	SPY	ETF	136.36	136.36	136.3	136.3	7700.0
2008-02-29 05:00:00	SPY	ETF	136.16	136.16	136.16	136.16	200.0
2008-02-29 05:30:00	SPY	ETF	136.17	136.17	136.0	136.02	5000.0
2008-02-29 06:00:00	SPY	ETF	135.97	135.97	135.41	135.59	33100.0
2008-02-29 06:30:00	SPY	ETF	135.59	135.77	135.33	135.71	478500.0
2008-02-29 07:00:00	SPY	ETF	135.71	135.75	135.51	135.74	311600.0
2008-02-29 07:30:00	SPY	ETF	135.77	135.86	135.2	135.32	1233400.0
2008-02-29 08:00:00	SPY	ETF	135.32	135.6	135.17	135.39	2506500.0
2008-02-29 08:30:00	SPY	ETF	135.38	136.87	135.36	135.68	2270700.0
2008-02-29 09:00:00	SPY	ETF	135.68	135.79	135.47	135.59	1144503.0
2008-02-29 09:30:00	SPY	ETF	135.6	135.68	134.81	135.15	29003925.0
2008-02-29 10:00:00	SPY	ETF	135.16	135.23	134.51	134.71	18545991.0
2008-02-29 10:30:00	SPY	ETF	134.7	134.73	134.25	134.59	15990549.0
2008-02-29 11:00:00	SPY	ETF	134.58	134.77	134.39	134.64	9337355.0
2008-02-29 11:30:00	SPY	ETF	134.64	134.94	134.58	134.7	9973395.0
2008-02-29 12:00:00	SPY	ETF	134.7	134.98	134.4	134.88	10954596.0
2008-02-29 12:30:00	SPY	ETF	134.87	134.92	134.47	134.63	5398490.0
2008-02-29 13:00:00	SPY	ETF	134.64	134.86	134.55	134.64	11614681.0
2008-02-29 13:30:00	SPY	ETF	134.6315	134.64	133.86	133.88	19535613.0
2008-02-29 14:00:00	SPY	ETF	133.88	134.01	133.63	133.77	14224144.0
2008-02-29 14:30:00	SPY	ETF	133.78	133.99	133.51	133.81	14599583.0
2008-02-29 15:00:00	SPY	ETF	133.81	137.0249	133.39	133.71	17678040.0
2008-02-29 15:30:00	SPY	ETF	133.7	133.76	132.78	133.23	34821902.0
2008-02-29 16:00:00	SPY	ETF	133.48	137.0249	133.23	133.6	12883000.0
2008-02-29 16:30:00	SPY	ETF	133.6	138.22	133.42	133.42	9755900.0
2008-02-29 17:00:00	SPY	ETF	137.0249	137.0249	133.37	133.37	2602500.0
2008-02-29 17:30:00	SPY	ETF	133.43	133.65	133.43	133.64	91700.0
2008-02-29 18:00:00	SPY	ETF	133.58	133.59	133.48	133.52	11300.0
2008-02-29 18:30:00	SPY	ETF	133.5	133.52	133.46	133.46	3100.0
2008-02-29 19:00:00	SPY	ETF	133.46	133.52	133.46	133.5	18300.0
2008-02-29 19:30:00	SPY	ETF	133.52	133.52	133.41	133.41	32400.0
2008-02-29 05:30:00	QQQ	ETF	43.57	43.57	43.57	43.57	6000.0
2008-02-29 06:00:00	QQQ	ETF	43.61	43.61	43.29	43.29	2400.0
2008-02-29 06:30:00	QQQ	ETF	43.45	43.52	43.43	43.5	37500.0
2008-02-29 07:00:00	QQQ	ETF	43.56	43.57	43.48	43.52	52849.0
2008-02-29 07:30:00	QQQ	ETF	43.52	43.57	43.4	43.43	145892.0
2008-02-29 08:00:00	QQQ	ETF	43.43	43.64	43.39	43.46	753470.0
2008-02-29 08:30:00	QQQ	ETF	43.47	43.61	43.46	43.58	1489417.0
2008-02-29 09:00:00	QQQ	ETF	43.6	43.66	43.54	43.65	855648.0
2008-02-29 09:30:00	QQQ	ETF	43.65	43.77	43.5	43.67	16733404.0
2008-02-29 10:00:00	QQQ	ETF	43.68	43.68	43.17	43.3	30185960.0
2008-02-29 10:30:00	QQQ	ETF	43.3	43.34	43.19	43.29	9663601.0
2008-02-29 11:00:00	QQQ	ETF	43.29	43.34	43.21	43.29	6834958.0
2008-02-29 11:30:00	QQQ	ETF	43.29	43.39	43.23	43.29	5956624.0
2008-02-29 12:00:00	QQQ	ETF	43.299	43.39	43.21	43.36	5463768.0
2008-02-29 12:30:00	QQQ	ETF	43.36	43.39	43.24	43.35	5868784.0
2008-02-29 13:00:00	QQQ	ETF	43.35	43.48	43.3	43.361	13221841.0
2008-02-29 13:30:00	QQQ	ETF	43.36	43.36	43.1	43.11	11452081.0
2008-02-29 14:00:00	QQQ	ETF	43.11	43.19	43.05	43.11	12029063.0
2008-02-29 14:30:00	QQQ	ETF	43.11	43.24	43.0	43.14	10938277.0

> showing 50 of 5,781 rows — these rows as CSV

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