PREVIEW / etf_1hour / 2007-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-06.parquet
  size:    90 KB
  rows:    2,950

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-08-06 05:00:00	SPY	ETF	144.52	144.54	144.48	144.54	18000.0
2007-08-06 06:00:00	SPY	ETF	144.72	144.95	144.67	144.87	56100.0
2007-08-06 07:00:00	SPY	ETF	144.84	144.93	144.34	144.46	2177900.0
2007-08-06 08:00:00	SPY	ETF	144.5	144.89	143.0	144.4	5829600.0
2007-08-06 09:00:00	SPY	ETF	144.4	144.51	142.94	144.11	47685193.0
2007-08-06 10:00:00	SPY	ETF	144.12	144.21	142.53	143.22	54692221.0
2007-08-06 11:00:00	SPY	ETF	143.23	144.71	142.94	144.28	49292660.0
2007-08-06 12:00:00	SPY	ETF	144.29	145.18	143.73	144.87	29967730.0
2007-08-06 13:00:00	SPY	ETF	144.87	144.88	144.01	144.08	27338404.0
2007-08-06 14:00:00	SPY	ETF	144.08	145.6	144.05	145.2	31546596.0
2007-08-06 15:00:00	SPY	ETF	145.2	146.83	145.14	146.77	51538261.0
2007-08-06 16:00:00	SPY	ETF	146.72	146.865	142.8	146.41	17437600.0
2007-08-06 17:00:00	SPY	ETF	146.4	146.5	146.25	146.31	970100.0
2007-08-06 18:00:00	SPY	ETF	146.32	146.4	146.31	146.34	33200.0
2007-08-06 19:00:00	SPY	ETF	146.34	146.34	146.21	146.32	248600.0
2007-08-06 06:00:00	QQQ	ETF	47.66	47.66	47.64	47.64	7700.0
2007-08-06 07:00:00	QQQ	ETF	47.67	47.69	47.54	47.57	230401.0
2007-08-06 08:00:00	QQQ	ETF	47.57	48.0	47.46	47.5	818367.0
2007-08-06 09:00:00	QQQ	ETF	47.5	47.59	47.07	47.44	26681631.0
2007-08-06 10:00:00	QQQ	ETF	47.43	47.45	47.03	47.16	41454049.0
2007-08-06 11:00:00	QQQ	ETF	47.16	47.58	47.05	47.41	31424729.0
2007-08-06 12:00:00	QQQ	ETF	47.42	47.77	47.32	47.67	24459794.0
2007-08-06 13:00:00	QQQ	ETF	47.67	47.69	47.33	47.38	13436751.0
2007-08-06 14:00:00	QQQ	ETF	47.37	47.85	47.352	47.7222	21106980.0
2007-08-06 15:00:00	QQQ	ETF	47.72	48.02	47.7	47.98	22125779.0
2007-08-06 16:00:00	QQQ	ETF	47.99	48.03	47.88	47.97	4086032.0
2007-08-06 17:00:00	QQQ	ETF	47.97	48.04	47.97	48.0	37739.0
2007-08-06 18:00:00	QQQ	ETF	48.0	48.02	47.98	47.99	84306.0
2007-08-06 19:00:00	QQQ	ETF	47.99	48.0	47.96	48.0	79639.0
2007-08-06 06:00:00	IWM	ETF	75.97	75.97	75.97	75.97	100.0
2007-08-06 07:00:00	IWM	ETF	75.97	75.97	75.73	75.78	217700.0
2007-08-06 08:00:00	IWM	ETF	75.79	75.8	75.48	75.7	1431700.0
2007-08-06 09:00:00	IWM	ETF	75.68	75.74	73.92	75.13	30582933.0
2007-08-06 10:00:00	IWM	ETF	75.13	75.23	73.97	74.2	25364896.0
2007-08-06 11:00:00	IWM	ETF	74.21	75.42	73.98	74.99	24416115.0
2007-08-06 12:00:00	IWM	ETF	74.99	75.63	74.52	75.47	19245262.0
2007-08-06 13:00:00	IWM	ETF	75.47	75.57	74.81	74.89	21726683.0
2007-08-06 14:00:00	IWM	ETF	74.89	76.06	74.85	75.89	27817516.0
2007-08-06 15:00:00	IWM	ETF	75.89	76.43	75.12	76.26	38431081.0
2007-08-06 16:00:00	IWM	ETF	76.26	76.3	76.0	76.11	1460100.0
2007-08-06 17:00:00	IWM	ETF	76.13	76.18	76.13	76.18	757000.0
2007-08-06 18:00:00	IWM	ETF	76.1	76.1	76.03	76.1	100000.0
2007-08-06 19:00:00	IWM	ETF	76.11	76.11	76.03	76.03	45000.0
2007-08-06 07:00:00	DIA	ETF	132.83	132.9	132.44	132.53	3700.0
2007-08-06 08:00:00	DIA	ETF	132.6	132.6	132.18	132.47	192200.0
2007-08-06 09:00:00	DIA	ETF	132.47	132.64	131.56	132.45	3742100.0
2007-08-06 10:00:00	DIA	ETF	132.46	132.51	131.54	131.9	5954000.0
2007-08-06 11:00:00	DIA	ETF	131.88	132.8	131.66	132.55	5018500.0
2007-08-06 12:00:00	DIA	ETF	132.57	133.25	132.3	133.02	2517800.0
2007-08-06 13:00:00	DIA	ETF	132.98	133.04	132.34	132.42	2769200.0

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

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