PREVIEW / etf_30min / 2007-12-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-19.parquet
  size:    140 KB
  rows:    5,212

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-12-19 04:30:00	SPY	ETF	145.62	145.62	145.55	145.55	3600.0
2007-12-19 05:00:00	SPY	ETF	145.57	145.62	145.1	145.15	6800.0
2007-12-19 05:30:00	SPY	ETF	145.24	145.24	145.24	145.24	2000.0
2007-12-19 06:00:00	SPY	ETF	145.39	145.39	145.39	145.39	1000.0
2007-12-19 06:30:00	SPY	ETF	145.53	145.62	145.47	145.47	68100.0
2007-12-19 07:00:00	SPY	ETF	145.38	145.47	145.23	145.39	182900.0
2007-12-19 07:30:00	SPY	ETF	145.36	145.86	145.1	145.5	1269800.0
2007-12-19 08:00:00	SPY	ETF	145.2	145.97	145.19	145.95	1595800.0
2007-12-19 08:30:00	SPY	ETF	145.94	146.343	145.83	146.03	885400.0
2007-12-19 09:00:00	SPY	ETF	146.02	146.2	145.94	145.94	1105889.0
2007-12-19 09:30:00	SPY	ETF	145.94	146.6	145.69	146.39	24510924.0
2007-12-19 10:00:00	SPY	ETF	146.41	146.77	146.2	146.47	26235507.0
2007-12-19 10:30:00	SPY	ETF	146.46	146.89	146.43	146.54	10267526.0
2007-12-19 11:00:00	SPY	ETF	146.55	146.55	145.52	145.53	18360756.0
2007-12-19 11:30:00	SPY	ETF	145.52	145.77	145.11	145.27	17305349.0
2007-12-19 12:00:00	SPY	ETF	145.28	145.83	145.22	145.77	7538995.0
2007-12-19 12:30:00	SPY	ETF	145.77	145.77	145.33	145.6695	6170955.0
2007-12-19 13:00:00	SPY	ETF	145.67	145.67	145.2	145.34	5631863.0
2007-12-19 13:30:00	SPY	ETF	145.35	145.49	144.94	145.29	9715911.0
2007-12-19 14:00:00	SPY	ETF	145.29	146.31	145.2	146.14	16883855.0
2007-12-19 14:30:00	SPY	ETF	146.13	146.5	145.99	146.15	14369379.0
2007-12-19 15:00:00	SPY	ETF	146.15	146.35	145.82	145.98	12455041.0
2007-12-19 15:30:00	SPY	ETF	145.97	146.25	145.62	145.62	12739929.0
2007-12-19 16:00:00	SPY	ETF	145.69	146.168	145.61	145.8	5324600.0
2007-12-19 16:30:00	SPY	ETF	145.82	145.83	145.38	145.81	415000.0
2007-12-19 17:00:00	SPY	ETF	145.83	146.75	145.62	145.79	400800.0
2007-12-19 17:30:00	SPY	ETF	145.79	145.96	145.79	145.94	83800.0
2007-12-19 18:00:00	SPY	ETF	145.92	146.02	145.86	146.02	115900.0
2007-12-19 18:30:00	SPY	ETF	146.0	146.0	145.95	145.95	7800.0
2007-12-19 19:00:00	SPY	ETF	145.96	145.97	145.89	145.96	10000.0
2007-12-19 19:30:00	SPY	ETF	145.96	146.0	145.96	145.97	3100.0
2007-12-19 04:30:00	QQQ	ETF	49.85	49.85	49.85	49.85	200.0
2007-12-19 05:00:00	QQQ	ETF	49.7	49.7	49.7	49.7	200.0
2007-12-19 06:00:00	QQQ	ETF	49.8	49.82	49.8	49.82	12000.0
2007-12-19 07:00:00	QQQ	ETF	49.85	49.85	49.79	49.84	35374.0
2007-12-19 07:30:00	QQQ	ETF	49.81	49.99	49.76	49.88	672904.0
2007-12-19 08:00:00	QQQ	ETF	49.9	50.01	49.86	50.0	1662073.0
2007-12-19 08:30:00	QQQ	ETF	49.99	49.99	49.88	49.91	560266.0
2007-12-19 09:00:00	QQQ	ETF	49.92	49.98	49.86	49.86	457170.0
2007-12-19 09:30:00	QQQ	ETF	49.9	50.17	49.7999	50.09	16013798.0
2007-12-19 10:00:00	QQQ	ETF	50.09	50.2	50.0	50.09	11322542.0
2007-12-19 10:30:00	QQQ	ETF	50.08	50.15	49.98	50.03	7570137.0
2007-12-19 11:00:00	QQQ	ETF	50.03	50.0394	49.75	49.76	10043525.0
2007-12-19 11:30:00	QQQ	ETF	49.76	49.85	49.7	49.7	7275493.0
2007-12-19 12:00:00	QQQ	ETF	49.71	49.9595	49.65	49.9295	7321862.0
2007-12-19 12:30:00	QQQ	ETF	49.92	49.92	49.75	49.89	4187365.0
2007-12-19 13:00:00	QQQ	ETF	49.88	49.88	49.69	49.75	4557243.0
2007-12-19 13:30:00	QQQ	ETF	49.74	49.82	49.61	49.72	5868403.0
2007-12-19 14:00:00	QQQ	ETF	49.719	50.13	49.688	50.0701	10695855.0
2007-12-19 14:30:00	QQQ	ETF	50.078	50.18	50.02	50.08	16873181.0

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

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