PREVIEW / etf_30min / 2007-08-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-14.parquet
  size:    129 KB
  rows:    4,722

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
2007-08-14 04:00:00	SPY	ETF	145.38	145.38	145.38	145.38	2000.0
2007-08-14 06:30:00	SPY	ETF	145.56	145.56	145.27	145.36	93600.0
2007-08-14 07:00:00	SPY	ETF	145.22	145.44	145.09	145.38	160900.0
2007-08-14 07:30:00	SPY	ETF	145.4	145.47	145.36	145.46	191400.0
2007-08-14 08:00:00	SPY	ETF	145.45	145.61	145.15	145.6	1946100.0
2007-08-14 08:30:00	SPY	ETF	145.6	145.92	145.31	145.78	2034100.0
2007-08-14 09:00:00	SPY	ETF	145.78	145.9	145.5314	145.69	1105200.0
2007-08-14 09:30:00	SPY	ETF	145.7	146.06	145.1	145.44	24798312.0
2007-08-14 10:00:00	SPY	ETF	145.44	145.5	144.28	144.43	26556682.0
2007-08-14 10:30:00	SPY	ETF	144.43	144.7	143.82	144.03	22455334.0
2007-08-14 11:00:00	SPY	ETF	144.03	144.04	143.3	143.74	18840014.0
2007-08-14 11:30:00	SPY	ETF	143.74	144.8	143.65	144.53	18588911.0
2007-08-14 12:00:00	SPY	ETF	144.53	144.66	144.14	144.25	10807203.0
2007-08-14 12:30:00	SPY	ETF	144.25	144.57	144.05	144.38	6634342.0
2007-08-14 13:00:00	SPY	ETF	144.38	144.44	143.85	143.96	6466515.0
2007-08-14 13:30:00	SPY	ETF	143.96	144.44	143.45	143.68	11807325.0
2007-08-14 14:00:00	SPY	ETF	143.69	144.33	143.25	143.62	17509751.0
2007-08-14 14:30:00	SPY	ETF	143.62	143.66	143.02	143.38	22281708.0
2007-08-14 15:00:00	SPY	ETF	143.38	144.14	143.25	143.67	28837313.0
2007-08-14 15:30:00	SPY	ETF	143.68	143.7	142.75	142.77	29900082.0
2007-08-14 16:00:00	SPY	ETF	142.74	143.13	142.73	142.9	4589900.0
2007-08-14 16:30:00	SPY	ETF	142.9	143.14	142.84	142.92	1410800.0
2007-08-14 17:00:00	SPY	ETF	142.9	143.09	142.89	143.08	711400.0
2007-08-14 17:30:00	SPY	ETF	142.98	143.09	142.96	143.09	17400.0
2007-08-14 18:00:00	SPY	ETF	143.03	143.03	142.86	142.91	148300.0
2007-08-14 18:30:00	SPY	ETF	142.9	142.92	142.82	142.9	20600.0
2007-08-14 19:00:00	SPY	ETF	142.85	142.91	142.85	142.88	5300.0
2007-08-14 19:30:00	SPY	ETF	142.86	142.9	142.8	142.89	24800.0
2007-08-14 07:00:00	QQQ	ETF	47.48	47.53	47.46	47.53	26744.0
2007-08-14 07:30:00	QQQ	ETF	47.53	47.55	47.52	47.53	38300.0
2007-08-14 08:00:00	QQQ	ETF	47.52	47.59	47.48	47.57	197858.0
2007-08-14 08:30:00	QQQ	ETF	47.57	47.7	47.45	47.66	1522274.0
2007-08-14 09:00:00	QQQ	ETF	47.67	47.7	47.61	47.7	850825.0
2007-08-14 09:30:00	QQQ	ETF	47.69	47.74	47.53	47.66	11879621.0
2007-08-14 10:00:00	QQQ	ETF	47.67	47.6701	47.23	47.27	16843672.0
2007-08-14 10:30:00	QQQ	ETF	47.27	47.37	47.16	47.22	8803579.0
2007-08-14 11:00:00	QQQ	ETF	47.22	47.22	47.02	47.137	12030524.0
2007-08-14 11:30:00	QQQ	ETF	47.13	47.48	47.13	47.419	12935476.0
2007-08-14 12:00:00	QQQ	ETF	47.42	47.43	47.19	47.25	10264737.0
2007-08-14 12:30:00	QQQ	ETF	47.24	47.33	47.18	47.28	4317756.0
2007-08-14 13:00:00	QQQ	ETF	47.2715	47.31	47.16	47.18	4221915.0
2007-08-14 13:30:00	QQQ	ETF	47.17	47.34	47.0	47.09	7380379.0
2007-08-14 14:00:00	QQQ	ETF	47.08	47.12	46.96	47.0499	8819766.0
2007-08-14 14:30:00	QQQ	ETF	47.05	47.0589	46.84	46.95	9778841.0
2007-08-14 15:00:00	QQQ	ETF	46.96	47.17	46.91	47.06	11775219.0
2007-08-14 15:30:00	QQQ	ETF	47.05	47.08	46.75	46.75	16917862.0
2007-08-14 16:00:00	QQQ	ETF	46.76	46.86	46.73	46.8	5861592.0
2007-08-14 16:30:00	QQQ	ETF	46.8	46.86	46.78	46.8	418079.0
2007-08-14 17:00:00	QQQ	ETF	46.79	46.83	46.75	46.82	106152.0
2007-08-14 17:30:00	QQQ	ETF	46.83	46.85	46.79	46.81	23638.0

> showing 50 of 4,722 rows — these rows as CSV

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