PREVIEW / etf_1hour / 2007-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-25.parquet
  size:    86 KB
  rows:    2,853

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-25 04:00:00	SPY	ETF	151.52	151.62	151.37	151.61	17700.0
2007-07-25 05:00:00	SPY	ETF	151.52	151.68	151.52	151.68	6000.0
2007-07-25 06:00:00	SPY	ETF	151.68	151.86	151.68	151.77	27300.0
2007-07-25 07:00:00	SPY	ETF	151.76	152.18	151.73	152.07	1294600.0
2007-07-25 08:00:00	SPY	ETF	152.08	152.22	151.63	152.12	5981000.0
2007-07-25 09:00:00	SPY	ETF	152.12	152.39	151.53	152.16	21395471.0
2007-07-25 10:00:00	SPY	ETF	152.16	152.25	150.25	151.14	68895114.0
2007-07-25 11:00:00	SPY	ETF	151.14	151.82	150.74	151.4525	45457302.0
2007-07-25 12:00:00	SPY	ETF	151.46	151.68	151.0	151.27	16184687.0
2007-07-25 13:00:00	SPY	ETF	151.27	151.43	150.4	150.59	28011598.0
2007-07-25 14:00:00	SPY	ETF	150.59	151.27	150.39	151.18	23990131.0
2007-07-25 15:00:00	SPY	ETF	151.18	152.15	151.12	151.74	39194679.0
2007-07-25 16:00:00	SPY	ETF	151.73	152.24	151.0576	151.63	8316000.0
2007-07-25 17:00:00	SPY	ETF	151.65	152.25	151.56	152.08	2994900.0
2007-07-25 18:00:00	SPY	ETF	152.07	152.11	151.91	152.02	451500.0
2007-07-25 19:00:00	SPY	ETF	151.98	151.99	151.95	151.98	12400.0
2007-07-25 04:00:00	QQQ	ETF	49.46	49.5	49.46	49.5	2000.0
2007-07-25 05:00:00	QQQ	ETF	49.5	49.57	49.5	49.57	6000.0
2007-07-25 06:00:00	QQQ	ETF	49.56	49.56	49.56	49.56	500.0
2007-07-25 07:00:00	QQQ	ETF	49.55	49.69	49.53	49.65	1995294.0
2007-07-25 08:00:00	QQQ	ETF	49.66	49.67	49.6	49.62	1959118.0
2007-07-25 09:00:00	QQQ	ETF	49.62	49.67	49.48	49.63	17417037.0
2007-07-25 10:00:00	QQQ	ETF	49.62	49.64	49.06	49.35	35667896.0
2007-07-25 11:00:00	QQQ	ETF	49.34	49.49	49.22	49.36	30834419.0
2007-07-25 12:00:00	QQQ	ETF	49.36	49.5	49.24	49.35	11950008.0
2007-07-25 13:00:00	QQQ	ETF	49.3495	49.38	49.09	49.14	13425247.0
2007-07-25 14:00:00	QQQ	ETF	49.15	49.6306	49.1	49.26	17005196.0
2007-07-25 15:00:00	QQQ	ETF	49.26	49.57	49.25	49.43	22203507.0
2007-07-25 16:00:00	QQQ	ETF	49.43	49.65	49.13	49.38	11478608.0
2007-07-25 17:00:00	QQQ	ETF	49.35	49.88	49.33	49.76	1777185.0
2007-07-25 18:00:00	QQQ	ETF	49.73	49.78	49.7	49.74	251230.0
2007-07-25 19:00:00	QQQ	ETF	49.75	49.77	49.71	49.71	41115.0
2007-07-25 07:00:00	IWM	ETF	81.23	81.53	81.2	81.52	184500.0
2007-07-25 08:00:00	IWM	ETF	81.48	81.57	81.3	81.51	1307600.0
2007-07-25 09:00:00	IWM	ETF	81.5	81.77	81.28	81.55	15764092.0
2007-07-25 10:00:00	IWM	ETF	81.55	81.61	80.15	80.67	37555023.0
2007-07-25 11:00:00	IWM	ETF	80.67	81.0	80.4	80.63	27297319.0
2007-07-25 12:00:00	IWM	ETF	80.64	80.7	80.35	80.48	11315790.0
2007-07-25 13:00:00	IWM	ETF	80.48	80.57	79.92	79.98	14449798.0
2007-07-25 14:00:00	IWM	ETF	79.98	80.51	79.83	80.49	15592929.0
2007-07-25 15:00:00	IWM	ETF	80.49	81.1	80.44	80.82	20104648.0
2007-07-25 16:00:00	IWM	ETF	80.83	80.86	80.47	80.71	13490300.0
2007-07-25 17:00:00	IWM	ETF	80.7	81.0	80.67	80.9	169900.0
2007-07-25 18:00:00	IWM	ETF	80.98	81.01	80.7	80.9	523300.0
2007-07-25 19:00:00	IWM	ETF	80.95	80.97	80.95	80.97	2500.0
2007-07-25 07:00:00	DIA	ETF	137.81	138.0	137.81	138.0	37900.0
2007-07-25 08:00:00	DIA	ETF	137.72	138.08	137.72	137.98	177200.0
2007-07-25 09:00:00	DIA	ETF	138.0	138.1	137.66	137.76	1919400.0
2007-07-25 10:00:00	DIA	ETF	137.76	137.82	136.71	137.3	5256100.0
2007-07-25 11:00:00	DIA	ETF	137.29	137.72	136.96	137.44	3444700.0

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

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