PREVIEW / etf_30min / 2007-05-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-04.parquet
  size:    107 KB
  rows:    3,885

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-05-04 05:00:00	SPY	ETF	150.49	150.49	150.49	150.49	9700.0
2007-05-04 06:00:00	SPY	ETF	150.76	150.82	150.74	150.78	36800.0
2007-05-04 06:30:00	SPY	ETF	150.8	150.8	150.8	150.8	2000.0
2007-05-04 07:00:00	SPY	ETF	150.78	150.78	150.7	150.7	103500.0
2007-05-04 07:30:00	SPY	ETF	150.7	150.85	150.69	150.78	491000.0
2007-05-04 08:00:00	SPY	ETF	150.77	150.95	150.77	150.92	2069400.0
2007-05-04 08:30:00	SPY	ETF	150.99	151.25	150.77	150.79	4181000.0
2007-05-04 09:00:00	SPY	ETF	150.79	150.92	150.73	150.75	1346900.0
2007-05-04 09:30:00	SPY	ETF	150.75	150.82	150.43	150.77	10528623.0
2007-05-04 10:00:00	SPY	ETF	150.77	151.12	150.67	151.01	8584825.0
2007-05-04 10:30:00	SPY	ETF	151.0	151.06	150.79	150.98	5911180.0
2007-05-04 11:00:00	SPY	ETF	150.98	151.03	150.72	150.8	6139949.0
2007-05-04 11:30:00	SPY	ETF	150.79	150.87	150.72	150.74	3171150.0
2007-05-04 12:00:00	SPY	ETF	150.74	150.77	150.26	150.37	10265051.0
2007-05-04 12:30:00	SPY	ETF	150.37	150.57	150.22	150.56	7998046.0
2007-05-04 13:00:00	SPY	ETF	150.57	150.9375	150.42	150.56	3434100.0
2007-05-04 13:30:00	SPY	ETF	150.57	151.1	150.36	150.44	3671199.0
2007-05-04 14:00:00	SPY	ETF	150.44	151.03	150.34	150.48	3453702.0
2007-05-04 14:30:00	SPY	ETF	150.48	150.54	150.35	150.48	3570500.0
2007-05-04 15:00:00	SPY	ETF	150.48	150.69	150.45	150.66	4208250.0
2007-05-04 15:30:00	SPY	ETF	150.66	150.7	150.35	150.65	13481954.0
2007-05-04 16:00:00	SPY	ETF	150.65	150.95	150.54	150.95	1682100.0
2007-05-04 16:30:00	SPY	ETF	150.96	151.05	150.95	150.95	107600.0
2007-05-04 17:00:00	SPY	ETF	150.97	150.97	150.89	150.92	6500.0
2007-05-04 17:30:00	SPY	ETF	150.92	150.98	150.92	150.98	157500.0
2007-05-04 18:00:00	SPY	ETF	150.98	151.0	150.98	150.99	2400.0
2007-05-04 18:30:00	SPY	ETF	151.0	151.0	150.94	150.94	7100.0
2007-05-04 19:00:00	SPY	ETF	150.94	150.94	150.94	150.94	5000.0
2007-05-04 19:30:00	SPY	ETF	150.98	150.99	150.94	150.96	800.0
2007-05-04 04:30:00	QQQ	ETF	46.7	46.7	46.7	46.7	100.0
2007-05-04 05:00:00	QQQ	ETF	46.7	46.7	46.7	46.7	23805.0
2007-05-04 05:30:00	QQQ	ETF	46.7	46.8	46.7	46.8	2095.0
2007-05-04 06:30:00	QQQ	ETF	46.82	46.83	46.82	46.83	750.0
2007-05-04 07:00:00	QQQ	ETF	46.82	46.86	46.79	46.8	392129.0
2007-05-04 07:30:00	QQQ	ETF	46.79	46.88	46.79	46.84	248641.0
2007-05-04 08:00:00	QQQ	ETF	46.84	46.96	46.83	46.94	1973868.0
2007-05-04 08:30:00	QQQ	ETF	46.96	46.99	46.83	46.84	2660133.0
2007-05-04 09:00:00	QQQ	ETF	46.83	46.87	46.77	46.77	868970.0
2007-05-04 09:30:00	QQQ	ETF	46.77	46.8	46.66	46.74	8330744.0
2007-05-04 10:00:00	QQQ	ETF	46.75	46.89	46.71	46.85	6656597.0
2007-05-04 10:30:00	QQQ	ETF	46.84	46.85	46.75	46.8	4398909.0
2007-05-04 11:00:00	QQQ	ETF	46.8	46.83	46.72	46.75	3257486.0
2007-05-04 11:30:00	QQQ	ETF	46.75	46.78	46.73	46.74	1637779.0
2007-05-04 12:00:00	QQQ	ETF	46.74	46.76	46.46	46.49	12566585.0
2007-05-04 12:30:00	QQQ	ETF	46.49	46.64	46.42	46.63	6965550.0
2007-05-04 13:00:00	QQQ	ETF	46.63	46.66	46.55	46.63	4736066.0
2007-05-04 13:30:00	QQQ	ETF	46.62	46.65	46.47	46.51	9421115.0
2007-05-04 14:00:00	QQQ	ETF	46.51	46.59	46.48	46.5405	5176170.0
2007-05-04 14:30:00	QQQ	ETF	46.54	46.57	46.49	46.54	4667803.0
2007-05-04 15:00:00	QQQ	ETF	46.54	46.61	46.52	46.6	2996252.0

> showing 50 of 3,885 rows — these rows as CSV

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