PREVIEW / etf_1hour / 2007-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-12.parquet
  size:    83 KB
  rows:    2,781

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-07-12 05:00:00	SPY	ETF	152.18	152.18	152.18	152.18	2000.0
2007-07-12 06:00:00	SPY	ETF	152.04	152.06	151.98	152.03	136300.0
2007-07-12 07:00:00	SPY	ETF	152.11	152.46	152.08	152.45	804600.0
2007-07-12 08:00:00	SPY	ETF	152.44	152.53	152.03	152.45	2218600.0
2007-07-12 09:00:00	SPY	ETF	152.46	153.03	152.34	152.94	16712550.0
2007-07-12 10:00:00	SPY	ETF	152.94	153.2	152.71	153.05	20777069.0
2007-07-12 11:00:00	SPY	ETF	153.05	153.32	152.97	153.2	13730106.0
2007-07-12 12:00:00	SPY	ETF	153.21	153.62	153.2	153.52	13484106.0
2007-07-12 13:00:00	SPY	ETF	153.51	153.77	153.48	153.59	10325876.0
2007-07-12 14:00:00	SPY	ETF	153.6	153.86	153.35	153.8	15917665.0
2007-07-12 15:00:00	SPY	ETF	153.8	154.75	152.7	154.73	29255472.0
2007-07-12 16:00:00	SPY	ETF	154.72	154.72	152.87	154.45	3332600.0
2007-07-12 17:00:00	SPY	ETF	154.44	154.45	154.36	154.44	660300.0
2007-07-12 18:00:00	SPY	ETF	154.43	154.44	154.38	154.41	327800.0
2007-07-12 19:00:00	SPY	ETF	154.42	154.46	154.39	154.44	18100.0
2007-07-12 04:00:00	QQQ	ETF	48.87	48.87	48.87	48.87	500.0
2007-07-12 07:00:00	QQQ	ETF	48.93	49.02	48.89	49.02	211961.0
2007-07-12 08:00:00	QQQ	ETF	49.01	49.06	49.0	49.04	1951221.0
2007-07-12 09:00:00	QQQ	ETF	49.03	49.08	48.92	49.05	17086777.0
2007-07-12 10:00:00	QQQ	ETF	49.05	49.1	48.94	49.0515	10235747.0
2007-07-12 11:00:00	QQQ	ETF	49.06	49.17	49.04	49.12	15330008.0
2007-07-12 12:00:00	QQQ	ETF	49.11	49.29	49.11	49.27	10690668.0
2007-07-12 13:00:00	QQQ	ETF	49.27	49.36	49.24	49.3	9528342.0
2007-07-12 14:00:00	QQQ	ETF	49.3	49.42	49.23	49.4	10164333.0
2007-07-12 15:00:00	QQQ	ETF	49.3989	49.67	49.38	49.66	25212668.0
2007-07-12 16:00:00	QQQ	ETF	49.66	49.67	49.54	49.57	1336562.0
2007-07-12 17:00:00	QQQ	ETF	49.58	49.61	49.55	49.56	61994.0
2007-07-12 18:00:00	QQQ	ETF	49.58	49.6	49.56	49.57	4878.0
2007-07-12 19:00:00	QQQ	ETF	49.56	49.59	49.56	49.56	5242.0
2007-07-12 07:00:00	IWM	ETF	83.87	84.07	83.87	84.07	100500.0
2007-07-12 08:00:00	IWM	ETF	84.07	84.15	84.03	84.1	793500.0
2007-07-12 09:00:00	IWM	ETF	84.12	84.56	84.02	84.48	11950162.0
2007-07-12 10:00:00	IWM	ETF	84.47	84.53	84.25	84.42	7828697.0
2007-07-12 11:00:00	IWM	ETF	84.42	84.57	84.33	84.39	5824457.0
2007-07-12 12:00:00	IWM	ETF	84.39	84.64	84.38	84.62	4851262.0
2007-07-12 13:00:00	IWM	ETF	84.62	84.76	84.59	84.65	3481300.0
2007-07-12 14:00:00	IWM	ETF	84.66	84.71	84.5	84.68	4935197.0
2007-07-12 15:00:00	IWM	ETF	84.67	85.09	84.6	85.09	13608457.0
2007-07-12 16:00:00	IWM	ETF	85.09	85.1	84.75	84.82	9549500.0
2007-07-12 17:00:00	IWM	ETF	84.81	84.82	84.81	84.82	82300.0
2007-07-12 18:00:00	IWM	ETF	84.82	84.87	84.82	84.86	600.0
2007-07-12 07:00:00	DIA	ETF	136.05	136.45	136.03	136.45	58000.0
2007-07-12 08:00:00	DIA	ETF	136.4	136.47	136.32	136.35	110300.0
2007-07-12 09:00:00	DIA	ETF	136.38	136.94	136.32	136.87	1732600.0
2007-07-12 10:00:00	DIA	ETF	136.87	137.13	136.76	137.09	1823167.0
2007-07-12 11:00:00	DIA	ETF	137.09	137.43	137.04	137.35	1625500.0
2007-07-12 12:00:00	DIA	ETF	137.35	137.65	137.35	137.57	1975000.0
2007-07-12 13:00:00	DIA	ETF	137.58	137.83	137.57	137.68	1640700.0
2007-07-12 14:00:00	DIA	ETF	137.67	137.93	137.51	137.87	1585336.0
2007-07-12 15:00:00	DIA	ETF	137.87	138.67	137.83	138.66	2638341.0

> showing 50 of 2,781 rows — these rows as CSV

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