PREVIEW / etf_30min / 2007-05-29

all etf 30-min files

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

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-29 06:30:00	SPY	ETF	152.13	152.13	151.9	151.9	10000.0
2007-05-29 07:00:00	SPY	ETF	152.03	152.07	152.02	152.06	45500.0
2007-05-29 07:30:00	SPY	ETF	152.06	152.06	152.0	152.05	70100.0
2007-05-29 08:00:00	SPY	ETF	152.04	152.14	151.73	152.05	507700.0
2007-05-29 08:30:00	SPY	ETF	152.04	152.09	152.03	152.04	54900.0
2007-05-29 09:00:00	SPY	ETF	152.03	152.09	151.92	151.93	277100.0
2007-05-29 09:30:00	SPY	ETF	151.94	152.38	151.89	152.36	10478786.0
2007-05-29 10:00:00	SPY	ETF	152.35	152.5	152.08	152.22	12157954.0
2007-05-29 10:30:00	SPY	ETF	152.22	152.39	152.01	152.29	3410959.0
2007-05-29 11:00:00	SPY	ETF	152.3	152.35	152.16	152.32	4161282.0
2007-05-29 11:30:00	SPY	ETF	152.31	152.44	151.97	151.98	4802500.0
2007-05-29 12:00:00	SPY	ETF	151.98	152.05	151.78	151.78	5497913.0
2007-05-29 12:30:00	SPY	ETF	151.78	152.0	151.72	151.95	3240196.0
2007-05-29 13:00:00	SPY	ETF	151.96	152.07	151.5	151.67	5984434.0
2007-05-29 13:30:00	SPY	ETF	151.66	151.7	151.45	151.67	6049094.0
2007-05-29 14:00:00	SPY	ETF	151.66	151.78	151.52	151.63	5178900.0
2007-05-29 14:30:00	SPY	ETF	151.62	151.83	151.5	151.76	4993020.0
2007-05-29 15:00:00	SPY	ETF	151.75	151.99	151.73	151.89	4959638.0
2007-05-29 15:30:00	SPY	ETF	151.89	152.17	151.79	152.08	8094618.0
2007-05-29 16:00:00	SPY	ETF	152.11	152.28	152.08	152.2	704500.0
2007-05-29 16:30:00	SPY	ETF	152.18	152.18	152.11	152.15	588500.0
2007-05-29 17:00:00	SPY	ETF	152.14	152.15	152.14	152.15	3900.0
2007-05-29 17:30:00	SPY	ETF	152.13	152.13	152.13	152.13	1000.0
2007-05-29 18:00:00	SPY	ETF	152.1	152.12	152.1	152.12	1939500.0
2007-05-29 18:30:00	SPY	ETF	152.14	152.14	152.14	152.14	100.0
2007-05-29 19:30:00	SPY	ETF	152.12	152.14	152.12	152.14	1100.0
2007-05-29 07:30:00	QQQ	ETF	46.52	46.52	46.49	46.52	56997.0
2007-05-29 08:00:00	QQQ	ETF	46.51	46.55	46.51	46.52	259401.0
2007-05-29 08:30:00	QQQ	ETF	46.52	46.53	46.52	46.53	56287.0
2007-05-29 09:00:00	QQQ	ETF	46.51	46.53	46.49	46.49	834234.0
2007-05-29 09:30:00	QQQ	ETF	46.49	46.81	46.48	46.75	12015924.0
2007-05-29 10:00:00	QQQ	ETF	46.75	46.86	46.65	46.73	10980631.0
2007-05-29 10:30:00	QQQ	ETF	46.73	46.86	46.72	46.79	6423544.0
2007-05-29 11:00:00	QQQ	ETF	46.79	46.82	46.71	46.77	6764247.0
2007-05-29 11:30:00	QQQ	ETF	46.77	46.82	46.66	46.66	4236446.0
2007-05-29 12:00:00	QQQ	ETF	46.67	46.7	46.58	46.58	4530820.0
2007-05-29 12:30:00	QQQ	ETF	46.58	46.67	46.56	46.66	4135251.0
2007-05-29 13:00:00	QQQ	ETF	46.66	46.7	46.47	46.55	5687956.0
2007-05-29 13:30:00	QQQ	ETF	46.55	46.55	46.41	46.49	6016534.0
2007-05-29 14:00:00	QQQ	ETF	46.5	46.54	46.44	46.52	5143123.0
2007-05-29 14:30:00	QQQ	ETF	46.513	46.6	46.44	46.57	4540824.0
2007-05-29 15:00:00	QQQ	ETF	46.57	46.67	46.56	46.633	4330141.0
2007-05-29 15:30:00	QQQ	ETF	46.64	46.76	46.61	46.75	8114013.0
2007-05-29 16:00:00	QQQ	ETF	46.76	46.82	46.5	46.79	3803821.0
2007-05-29 16:30:00	QQQ	ETF	46.78	46.78	46.73	46.74	171252.0
2007-05-29 17:00:00	QQQ	ETF	46.74	46.77	46.71	46.74	15798.0
2007-05-29 17:30:00	QQQ	ETF	46.74	46.74	46.74	46.74	300.0
2007-05-29 18:00:00	QQQ	ETF	46.75	46.75	46.72	46.74	3617.0
2007-05-29 18:30:00	QQQ	ETF	46.74	46.74	46.74	46.74	5000.0
2007-05-29 19:00:00	QQQ	ETF	46.72	46.74	46.72	46.73	2800.0

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

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