PREVIEW / etf_30min / 2007-05-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-21.parquet
  size:    113 KB
  rows:    4,332

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-21 05:30:00	SPY	ETF	152.57	152.57	152.57	152.57	3000.0
2007-05-21 06:00:00	SPY	ETF	152.58	152.66	152.58	152.64	22500.0
2007-05-21 06:30:00	SPY	ETF	152.66	152.66	152.64	152.64	5000.0
2007-05-21 07:00:00	SPY	ETF	152.62	152.69	152.6	152.66	20300.0
2007-05-21 07:30:00	SPY	ETF	152.69	152.76	152.66	152.76	117300.0
2007-05-21 08:00:00	SPY	ETF	152.64	152.75	152.64	152.66	237200.0
2007-05-21 08:30:00	SPY	ETF	152.66	152.69	152.56	152.58	535700.0
2007-05-21 09:00:00	SPY	ETF	152.59	152.6	152.55	152.57	209000.0
2007-05-21 09:30:00	SPY	ETF	152.58	152.76	152.5	152.61	17426848.0
2007-05-21 10:00:00	SPY	ETF	152.61	152.82	152.58	152.62	20208259.0
2007-05-21 10:30:00	SPY	ETF	152.62	152.92	152.6	152.87	18667862.0
2007-05-21 11:00:00	SPY	ETF	152.88	152.91	152.79	152.82	38785772.0
2007-05-21 11:30:00	SPY	ETF	152.8275	152.91	152.73	152.85	36255113.0
2007-05-21 12:00:00	SPY	ETF	152.85	153.18	152.84	153.09	8376106.0
2007-05-21 12:30:00	SPY	ETF	153.09	153.2	152.99	153.02	2835234.0
2007-05-21 13:00:00	SPY	ETF	153.025	153.17	152.99	153.08	1495200.0
2007-05-21 13:30:00	SPY	ETF	153.07	153.1	152.87	152.98	3553785.0
2007-05-21 14:00:00	SPY	ETF	152.975	153.07	152.93	153.01	1463300.0
2007-05-21 14:30:00	SPY	ETF	153.01	153.23	152.97	153.03	3858958.0
2007-05-21 15:00:00	SPY	ETF	153.03	153.03	152.5	152.55	8067596.0
2007-05-21 15:30:00	SPY	ETF	152.55	152.77	152.52	152.71	7526114.0
2007-05-21 16:00:00	SPY	ETF	152.72	152.72	152.56	152.6	2220900.0
2007-05-21 16:30:00	SPY	ETF	152.58	152.58	152.44	152.47	60200.0
2007-05-21 17:00:00	SPY	ETF	152.5	152.55	152.5	152.5	1282800.0
2007-05-21 17:30:00	SPY	ETF	152.5	152.5	152.5	152.5	3000.0
2007-05-21 18:00:00	SPY	ETF	152.5	152.55	152.47	152.55	41400.0
2007-05-21 18:30:00	SPY	ETF	152.57	152.57	152.57	152.57	400.0
2007-05-21 19:00:00	SPY	ETF	152.63	152.63	152.63	152.63	200.0
2007-05-21 19:30:00	SPY	ETF	152.63	152.63	152.59	152.61	2500.0
2007-05-21 06:30:00	QQQ	ETF	46.8	46.8	46.8	46.8	2500.0
2007-05-21 07:00:00	QQQ	ETF	46.77	46.78	46.77	46.78	20100.0
2007-05-21 07:30:00	QQQ	ETF	46.79	46.8	46.78	46.8	208666.0
2007-05-21 08:00:00	QQQ	ETF	46.8	46.83	46.78	46.79	132061.0
2007-05-21 08:30:00	QQQ	ETF	46.78	46.8	46.76	46.76	148628.0
2007-05-21 09:00:00	QQQ	ETF	46.76	46.77	46.73	46.73	345603.0
2007-05-21 09:30:00	QQQ	ETF	46.74	46.79	46.67	46.72	9012024.0
2007-05-21 10:00:00	QQQ	ETF	46.73	46.89	46.72	46.805	10048075.0
2007-05-21 10:30:00	QQQ	ETF	46.81	47.1	46.8	47.08	16694546.0
2007-05-21 11:00:00	QQQ	ETF	47.08	47.12	47.03	47.05	6654713.0
2007-05-21 11:30:00	QQQ	ETF	47.05	47.14	47.0105	47.13	5734228.0
2007-05-21 12:00:00	QQQ	ETF	47.13	47.24	47.08	47.16	8012793.0
2007-05-21 12:30:00	QQQ	ETF	47.16	47.19	47.11	47.12	2735616.0
2007-05-21 13:00:00	QQQ	ETF	47.12	47.16	47.08	47.14	2541130.0
2007-05-21 13:30:00	QQQ	ETF	47.14	47.14	47.03	47.09	7006603.0
2007-05-21 14:00:00	QQQ	ETF	47.09	47.12	47.07	47.0794	3763437.0
2007-05-21 14:30:00	QQQ	ETF	47.07	47.18	47.06	47.085	6624950.0
2007-05-21 15:00:00	QQQ	ETF	47.087	47.09	46.86	46.88	12242330.0
2007-05-21 15:30:00	QQQ	ETF	46.88	47.02	46.83	47.02	15809760.0
2007-05-21 16:00:00	QQQ	ETF	47.01	47.04	46.96	46.98	2378448.0
2007-05-21 16:30:00	QQQ	ETF	46.97	46.97	46.92	46.95	1764641.0

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

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