PREVIEW / etf_30min / 2009-03-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-16.parquet
  size:    212 KB
  rows:    7,069

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
2009-03-16 04:00:00	SPY	ETF	76.83	76.91	76.63	76.63	3800.0
2009-03-16 04:30:00	SPY	ETF	76.73	77.03	76.73	77.0	10230.0
2009-03-16 05:00:00	SPY	ETF	76.82	76.85	76.8	76.85	490.0
2009-03-16 05:30:00	SPY	ETF	76.95	77.31	76.94	77.31	90300.0
2009-03-16 06:00:00	SPY	ETF	77.28	77.33	77.19	77.19	75055.0
2009-03-16 06:30:00	SPY	ETF	77.18	77.31	77.06	77.06	132889.0
2009-03-16 07:00:00	SPY	ETF	77.07	77.25	76.95	77.19	632924.0
2009-03-16 07:30:00	SPY	ETF	77.21	77.3	77.13	77.22	514446.0
2009-03-16 08:00:00	SPY	ETF	77.22	77.25	77.03	77.08	1717880.0
2009-03-16 08:30:00	SPY	ETF	77.07	77.22	75.66	76.99	3141540.0
2009-03-16 09:00:00	SPY	ETF	76.99	77.11	76.83	76.95	2452644.0
2009-03-16 09:30:00	SPY	ETF	76.96	77.23	76.69	76.97	41693582.0
2009-03-16 10:00:00	SPY	ETF	76.97	77.11	76.55	76.66	24949180.0
2009-03-16 10:30:00	SPY	ETF	76.67	77.31	76.67	76.88	27826141.0
2009-03-16 11:00:00	SPY	ETF	76.88	77.64	76.82	77.47	22801020.0
2009-03-16 11:30:00	SPY	ETF	77.47	77.58	77.23	77.3	16680187.0
2009-03-16 12:00:00	SPY	ETF	77.3	77.44	77.13	77.39	12743107.0
2009-03-16 12:30:00	SPY	ETF	77.39	77.96	77.39	77.92	17527615.0
2009-03-16 13:00:00	SPY	ETF	77.91	77.95	77.57	77.68	16981417.0
2009-03-16 13:30:00	SPY	ETF	77.675	77.97	77.48	77.53	16947587.0
2009-03-16 14:00:00	SPY	ETF	77.54	77.57	77.15	77.2075	21383756.0
2009-03-16 14:30:00	SPY	ETF	77.24	77.49	76.83	76.9	26893017.0
2009-03-16 15:00:00	SPY	ETF	76.9	77.11	76.19	76.45	33903104.0
2009-03-16 15:30:00	SPY	ETF	76.46	77.4	75.81	75.93	39972771.0
2009-03-16 16:00:00	SPY	ETF	75.94	77.92	75.86	76.22	8603257.0
2009-03-16 16:30:00	SPY	ETF	76.22	76.32	75.86	76.21	2211537.0
2009-03-16 17:00:00	SPY	ETF	76.21	76.21	76.16	76.17	119610.0
2009-03-16 17:30:00	SPY	ETF	76.18	76.2	76.14	76.16	26998.0
2009-03-16 18:00:00	SPY	ETF	76.17	76.18	76.14	76.17	356564.0
2009-03-16 18:30:00	SPY	ETF	76.17	76.25	76.17	76.21	43477.0
2009-03-16 19:00:00	SPY	ETF	76.19	76.25	76.18	76.25	21490.0
2009-03-16 19:30:00	SPY	ETF	76.23	76.3	76.19	76.3	34326.0
2009-03-16 04:30:00	QQQ	ETF	28.91	28.94	28.91	28.94	2100.0
2009-03-16 05:00:00	QQQ	ETF	28.95	28.95	28.95	28.95	100.0
2009-03-16 05:30:00	QQQ	ETF	29.1	29.1	29.07	29.07	350.0
2009-03-16 06:00:00	QQQ	ETF	29.08	29.08	29.05	29.06	5300.0
2009-03-16 06:30:00	QQQ	ETF	29.08	29.09	28.98	28.98	4000.0
2009-03-16 07:00:00	QQQ	ETF	28.99	29.06	28.97	29.03	51812.0
2009-03-16 07:30:00	QQQ	ETF	29.04	29.07	29.04	29.07	260357.0
2009-03-16 08:00:00	QQQ	ETF	29.07	29.07	28.91	28.91	624669.0
2009-03-16 08:30:00	QQQ	ETF	28.91	28.99	28.9	28.92	537374.0
2009-03-16 09:00:00	QQQ	ETF	28.92	28.95	28.86	28.9	520184.0
2009-03-16 09:30:00	QQQ	ETF	28.89	28.98	28.54	28.62	21847435.0
2009-03-16 10:00:00	QQQ	ETF	28.62	28.68	28.35	28.4	18207160.0
2009-03-16 10:30:00	QQQ	ETF	28.4	28.61	28.37	28.38	12712706.0
2009-03-16 11:00:00	QQQ	ETF	28.37	28.73	28.36	28.68	20119705.0
2009-03-16 11:30:00	QQQ	ETF	28.68	28.71	28.61	28.65	8832369.0
2009-03-16 12:00:00	QQQ	ETF	28.65	28.68	28.58	28.68	5937209.0
2009-03-16 12:30:00	QQQ	ETF	28.68	28.94	28.68	28.9199	13054758.0
2009-03-16 13:00:00	QQQ	ETF	28.91	28.93	28.66	28.7005	10127299.0

> showing 50 of 7,069 rows — these rows as CSV

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