PREVIEW / etf_30min / 2007-05-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-01.parquet
  size:    111 KB
  rows:    3,850

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-01 06:30:00	SPY	ETF	148.52	148.52	148.49	148.49	100000.0
2007-05-01 07:00:00	SPY	ETF	148.51	148.6	148.51	148.57	117700.0
2007-05-01 07:30:00	SPY	ETF	148.53	148.59	148.5	148.59	369500.0
2007-05-01 08:00:00	SPY	ETF	148.53	148.59	148.29	148.5	285400.0
2007-05-01 08:30:00	SPY	ETF	148.49	148.55	148.46	148.49	206400.0
2007-05-01 09:00:00	SPY	ETF	148.49	148.52	148.39	148.51	1058600.0
2007-05-01 09:30:00	SPY	ETF	148.52	148.68	148.2	148.2601	14003576.0
2007-05-01 10:00:00	SPY	ETF	148.25	149.47	147.67	147.78	32140196.0
2007-05-01 10:30:00	SPY	ETF	147.78	148.23	147.73	148.23	11119290.0
2007-05-01 11:00:00	SPY	ETF	148.23	148.3	148.03	148.18	8686174.0
2007-05-01 11:30:00	SPY	ETF	148.18	148.43	148.06	148.07	10139089.0
2007-05-01 12:00:00	SPY	ETF	148.068	148.23	148.03	148.07	4336349.0
2007-05-01 12:30:00	SPY	ETF	148.07	148.22	148.02	148.04	2991043.0
2007-05-01 13:00:00	SPY	ETF	148.03	148.2374	147.76	147.96	7765989.0
2007-05-01 13:30:00	SPY	ETF	147.96	148.37	147.94	148.261	6786790.0
2007-05-01 14:00:00	SPY	ETF	148.27	148.55	148.13	148.41	7678600.0
2007-05-01 14:30:00	SPY	ETF	148.41	148.73	148.38	148.6028	8987736.0
2007-05-01 15:00:00	SPY	ETF	148.61	148.7	148.4	148.41	6062781.0
2007-05-01 15:30:00	SPY	ETF	148.41	148.65	148.38	148.61	6522921.0
2007-05-01 16:00:00	SPY	ETF	148.61	148.72	148.57	148.68	2175000.0
2007-05-01 16:30:00	SPY	ETF	148.65	148.72	148.62	148.62	318500.0
2007-05-01 17:00:00	SPY	ETF	148.64	148.67	148.64	148.64	324900.0
2007-05-01 17:30:00	SPY	ETF	148.72	148.77	148.7	148.76	103100.0
2007-05-01 18:00:00	SPY	ETF	148.74	148.76	148.72	148.72	68600.0
2007-05-01 18:30:00	SPY	ETF	148.72	148.74	148.68	148.74	13800.0
2007-05-01 19:00:00	SPY	ETF	148.75	148.75	148.71	148.71	10200.0
2007-05-01 19:30:00	SPY	ETF	148.7	148.78	148.7	148.78	2200.0
2007-05-01 07:00:00	QQQ	ETF	46.0	46.04	46.0	46.01	75800.0
2007-05-01 07:30:00	QQQ	ETF	46.01	46.05	46.01	46.05	195588.0
2007-05-01 08:00:00	QQQ	ETF	46.05	46.05	45.96	46.02	221733.0
2007-05-01 08:30:00	QQQ	ETF	46.02	46.04	45.99	45.99	467852.0
2007-05-01 09:00:00	QQQ	ETF	45.98	45.99	45.95	45.97	512629.0
2007-05-01 09:30:00	QQQ	ETF	45.97	46.08	45.87	45.93	16296141.0
2007-05-01 10:00:00	QQQ	ETF	45.93	46.0	45.67	45.74	34145192.0
2007-05-01 10:30:00	QQQ	ETF	45.74	45.92	45.72	45.92	12870656.0
2007-05-01 11:00:00	QQQ	ETF	45.92	45.95	45.81	45.885	6224615.0
2007-05-01 11:30:00	QQQ	ETF	45.88	45.97	45.81	45.82	6303329.0
2007-05-01 12:00:00	QQQ	ETF	45.83	45.86	45.76	45.76	4840752.0
2007-05-01 12:30:00	QQQ	ETF	45.76	45.85	45.76	45.8	2272999.0
2007-05-01 13:00:00	QQQ	ETF	45.78	45.79	45.66	45.76	6786994.0
2007-05-01 13:30:00	QQQ	ETF	45.76	45.93	45.74	45.88	7221983.0
2007-05-01 14:00:00	QQQ	ETF	45.88	46.01	45.84	46.0	8673032.0
2007-05-01 14:30:00	QQQ	ETF	46.01	46.14	45.98	46.05	12984473.0
2007-05-01 15:00:00	QQQ	ETF	46.05	46.1	45.96	45.96	6731392.0
2007-05-01 15:30:00	QQQ	ETF	45.97	46.08	45.95	46.07	5065060.0
2007-05-01 16:00:00	QQQ	ETF	46.07	46.13	46.06	46.12	799229.0
2007-05-01 16:30:00	QQQ	ETF	46.1	46.11	46.09	46.09	105499.0
2007-05-01 17:00:00	QQQ	ETF	46.09	46.09	46.06	46.06	20300.0
2007-05-01 17:30:00	QQQ	ETF	46.08	46.09	46.07	46.09	1900.0
2007-05-01 18:00:00	QQQ	ETF	46.09	46.1	46.09	46.1	13601.0

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

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