PREVIEW / etf_30min / 2007-10-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-29.parquet
  size:    129 KB
  rows:    4,949

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-10-29 05:00:00	SPY	ETF	154.05	154.05	154.05	154.05	2000.0
2007-10-29 05:30:00	SPY	ETF	154.07	154.07	154.07	154.07	1000.0
2007-10-29 06:00:00	SPY	ETF	153.94	154.0	153.94	154.0	8000.0
2007-10-29 06:30:00	SPY	ETF	153.95	154.05	153.95	154.05	105000.0
2007-10-29 07:00:00	SPY	ETF	154.05	154.08	153.98	154.08	36100.0
2007-10-29 07:30:00	SPY	ETF	154.08	154.22	154.07	154.15	317300.0
2007-10-29 08:00:00	SPY	ETF	154.16	154.16	154.0	154.11	378400.0
2007-10-29 08:30:00	SPY	ETF	154.12	154.17	154.0	154.01	213500.0
2007-10-29 09:00:00	SPY	ETF	154.01	154.05	153.91	153.93	1123764.0
2007-10-29 09:30:00	SPY	ETF	153.93	154.44	153.8	154.16	17570535.0
2007-10-29 10:00:00	SPY	ETF	154.16	154.19	153.66	153.91	13963375.0
2007-10-29 10:30:00	SPY	ETF	153.91	153.94	153.55	153.76	9949190.0
2007-10-29 11:00:00	SPY	ETF	153.76	154.15	153.6	153.91	6967500.0
2007-10-29 11:30:00	SPY	ETF	153.9	154.03	153.74	153.79	4248700.0
2007-10-29 12:00:00	SPY	ETF	153.79	154.12	153.75	154.0	4957700.0
2007-10-29 12:30:00	SPY	ETF	154.0	154.01	153.75	153.872	2634700.0
2007-10-29 13:00:00	SPY	ETF	153.87	153.97	153.78	153.91	3329600.0
2007-10-29 13:30:00	SPY	ETF	153.91	154.175	153.91	154.1601	3999300.0
2007-10-29 14:00:00	SPY	ETF	154.16	154.27	153.86	153.99	5740400.0
2007-10-29 14:30:00	SPY	ETF	153.9925	154.17	153.73	154.09	6400283.0
2007-10-29 15:00:00	SPY	ETF	154.08	154.29	153.97	154.28	7868534.0
2007-10-29 15:30:00	SPY	ETF	154.29	154.32	153.95	154.0	12267700.0
2007-10-29 16:00:00	SPY	ETF	153.98	154.3	153.98	154.13	2948200.0
2007-10-29 16:30:00	SPY	ETF	154.13	154.13	153.89	153.97	278000.0
2007-10-29 17:00:00	SPY	ETF	153.95	154.09	153.92	154.09	6400.0
2007-10-29 17:30:00	SPY	ETF	154.06	154.06	154.0	154.02	22900.0
2007-10-29 18:00:00	SPY	ETF	154.05	154.1	153.95	153.98	2000.0
2007-10-29 18:30:00	SPY	ETF	153.97	153.97	153.9	153.9	15700.0
2007-10-29 19:00:00	SPY	ETF	153.92	153.93	153.88	153.89	3200.0
2007-10-29 19:30:00	SPY	ETF	153.93	153.94	153.9	153.92	2800.0
2007-10-29 05:30:00	QQQ	ETF	54.29	54.29	54.29	54.29	25000.0
2007-10-29 06:00:00	QQQ	ETF	54.26	54.26	54.26	54.26	1000.0
2007-10-29 06:30:00	QQQ	ETF	54.28	54.29	54.28	54.29	15400.0
2007-10-29 07:00:00	QQQ	ETF	54.28	54.34	54.28	54.33	57804.0
2007-10-29 07:30:00	QQQ	ETF	54.31	54.33	54.27	54.27	251797.0
2007-10-29 08:00:00	QQQ	ETF	54.28	54.28	54.24	54.26	107126.0
2007-10-29 08:30:00	QQQ	ETF	54.26	54.27	54.21	54.22	266156.0
2007-10-29 09:00:00	QQQ	ETF	54.22	54.25	54.17	54.17	1423996.0
2007-10-29 09:30:00	QQQ	ETF	54.17	54.29	54.11	54.17	13325319.0
2007-10-29 10:00:00	QQQ	ETF	54.17	54.24	53.84	54.07	21539584.0
2007-10-29 10:30:00	QQQ	ETF	54.07	54.08	53.9	54.04	6379328.0
2007-10-29 11:00:00	QQQ	ETF	54.03	54.18	53.96	54.13	5821441.0
2007-10-29 11:30:00	QQQ	ETF	54.14	54.18	54.06	54.08	4016193.0
2007-10-29 12:00:00	QQQ	ETF	54.08	54.16	54.07	54.11	2451639.0
2007-10-29 12:30:00	QQQ	ETF	54.12	54.15	54.01	54.11	3232524.0
2007-10-29 13:00:00	QQQ	ETF	54.11	54.15	54.04	54.12	2036789.0
2007-10-29 13:30:00	QQQ	ETF	54.11	54.2695	54.11	54.2524	3223171.0
2007-10-29 14:00:00	QQQ	ETF	54.2501	54.33	54.13	54.17	7797679.0
2007-10-29 14:30:00	QQQ	ETF	54.17	54.1901	54.0	54.1	8546279.0
2007-10-29 15:00:00	QQQ	ETF	54.1	54.18	54.05	54.17	6092419.0

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

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