PREVIEW / etf_30min / 2007-12-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-28.parquet
  size:    139 KB
  rows:    5,238

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-28 06:30:00	SPY	ETF	148.18	148.21	148.18	148.21	30000.0
2007-12-28 07:00:00	SPY	ETF	148.55	148.61	148.5	148.6	166700.0
2007-12-28 07:30:00	SPY	ETF	148.53	148.98	148.5	148.85	234600.0
2007-12-28 08:00:00	SPY	ETF	148.83	148.9	147.76	148.78	3812600.0
2007-12-28 08:30:00	SPY	ETF	148.78	148.78	148.57	148.58	360800.0
2007-12-28 09:00:00	SPY	ETF	148.59	148.61	148.48	148.56	732199.0
2007-12-28 09:30:00	SPY	ETF	148.54	148.61	148.26	148.36	13550869.0
2007-12-28 10:00:00	SPY	ETF	148.35	148.35	147.47	147.89	15514855.0
2007-12-28 10:30:00	SPY	ETF	147.88	147.94	147.63	147.66	4505968.0
2007-12-28 11:00:00	SPY	ETF	147.66	147.96	147.58	147.87	4150553.0
2007-12-28 11:30:00	SPY	ETF	147.87	148.02	147.53	147.61	4663143.0
2007-12-28 12:00:00	SPY	ETF	147.61	147.67	147.23	147.28	5144725.0
2007-12-28 12:30:00	SPY	ETF	147.28	147.4	146.91	147.0	8022961.0
2007-12-28 13:00:00	SPY	ETF	147.01	147.25	146.9	147.1	7792770.0
2007-12-28 13:30:00	SPY	ETF	147.11	147.52	146.96	147.45	7913295.0
2007-12-28 14:00:00	SPY	ETF	147.46	147.55	147.3	147.48	4815740.0
2007-12-28 14:30:00	SPY	ETF	147.48	147.74	147.42	147.5	7336015.0
2007-12-28 15:00:00	SPY	ETF	147.5	147.68	147.33	147.52	5694636.0
2007-12-28 15:30:00	SPY	ETF	147.52	147.75	147.38	147.55	13358645.0
2007-12-28 16:00:00	SPY	ETF	147.6	147.68	147.0447	147.1	5299200.0
2007-12-28 16:30:00	SPY	ETF	147.1	147.39	147.05	147.1	1066800.0
2007-12-28 17:00:00	SPY	ETF	147.08	147.17	147.07	147.1	4300.0
2007-12-28 17:30:00	SPY	ETF	147.16	147.2	147.1	147.1	15800.0
2007-12-28 18:00:00	SPY	ETF	147.1	147.15	147.1	147.1	26800.0
2007-12-28 18:30:00	SPY	ETF	147.1	147.11	147.1	147.11	4500.0
2007-12-28 19:00:00	SPY	ETF	147.14	147.14	147.1	147.1	1600.0
2007-12-28 19:30:00	SPY	ETF	147.13	147.13	147.06	147.09	7200.0
2007-12-28 05:30:00	QQQ	ETF	51.97	51.97	51.97	51.97	3000.0
2007-12-28 06:00:00	QQQ	ETF	51.97	51.97	51.97	51.97	7000.0
2007-12-28 06:30:00	QQQ	ETF	52.0	52.02	52.0	52.02	9200.0
2007-12-28 07:00:00	QQQ	ETF	52.07	52.07	52.0	52.04	69200.0
2007-12-28 07:30:00	QQQ	ETF	52.07	52.21	52.05	52.18	141602.0
2007-12-28 08:00:00	QQQ	ETF	52.18	52.21	52.15	52.18	772377.0
2007-12-28 08:30:00	QQQ	ETF	52.19	52.19	52.08	52.1	534616.0
2007-12-28 09:00:00	QQQ	ETF	52.1	52.1	52.0	52.04	451146.0
2007-12-28 09:30:00	QQQ	ETF	52.04	52.16	51.97	52.04	10715124.0
2007-12-28 10:00:00	QQQ	ETF	52.03	52.1	51.75	51.9401	6767910.0
2007-12-28 10:30:00	QQQ	ETF	51.9499	51.97	51.86	51.86	2715590.0
2007-12-28 11:00:00	QQQ	ETF	51.87	51.94	51.78	51.89	2331566.0
2007-12-28 11:30:00	QQQ	ETF	51.89	51.95	51.8	51.84	1958293.0
2007-12-28 12:00:00	QQQ	ETF	51.83	51.86	51.65	51.67	3636027.0
2007-12-28 12:30:00	QQQ	ETF	51.6601	51.74	51.48	51.49	6602940.0
2007-12-28 13:00:00	QQQ	ETF	51.48	51.63	51.43	51.59	5963600.0
2007-12-28 13:30:00	QQQ	ETF	51.59	51.79	51.52	51.78	5287497.0
2007-12-28 14:00:00	QQQ	ETF	51.78	51.8	51.7	51.74	2571588.0
2007-12-28 14:30:00	QQQ	ETF	51.75	51.86	51.61	51.69	3921409.0
2007-12-28 15:00:00	QQQ	ETF	51.69	51.77	51.58	51.71	5796964.0
2007-12-28 15:30:00	QQQ	ETF	51.71	51.8	51.64	51.79	6499237.0
2007-12-28 16:00:00	QQQ	ETF	51.79	51.86	51.71	51.72	957435.0
2007-12-28 16:30:00	QQQ	ETF	51.72	51.78	51.71	51.74	114209.0

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

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