PREVIEW / etf_1hour / 2007-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-06.parquet
  size:    70 KB
  rows:    2,189

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-03-06 05:00:00	SPY	ETF	138.66	138.74	138.66	138.74	400.0
2007-03-06 06:00:00	SPY	ETF	138.9	139.1	138.76	138.79	184800.0
2007-03-06 07:00:00	SPY	ETF	138.85	138.9	138.64	138.81	1269500.0
2007-03-06 08:00:00	SPY	ETF	138.84	138.95	138.1	138.8	4770800.0
2007-03-06 09:00:00	SPY	ETF	138.79	139.25	138.71	139.04	15603800.0
2007-03-06 10:00:00	SPY	ETF	139.05	139.08	138.44	138.51	17601600.0
2007-03-06 11:00:00	SPY	ETF	138.509	139.2	137.95	139.09	11698400.0
2007-03-06 12:00:00	SPY	ETF	139.1	139.3	138.92	139.29	11330600.0
2007-03-06 13:00:00	SPY	ETF	139.28	139.63	139.07	139.5	24254400.0
2007-03-06 14:00:00	SPY	ETF	139.5	139.85	139.4	139.85	15600800.0
2007-03-06 15:00:00	SPY	ETF	139.85	140.12	139.71	139.8	28601300.0
2007-03-06 16:00:00	SPY	ETF	139.81	139.85	138.89	138.89	7936600.0
2007-03-06 17:00:00	SPY	ETF	139.7	139.83	139.7	139.77	305700.0
2007-03-06 18:00:00	SPY	ETF	139.77	139.85	139.73	139.82	47200.0
2007-03-06 19:00:00	SPY	ETF	139.81	139.9	139.81	139.88	66400.0
2007-03-06 05:00:00	QQQ	ETF	42.51	42.53	42.51	42.53	20200.0
2007-03-06 06:00:00	QQQ	ETF	42.61	42.64	42.6	42.63	76179.0
2007-03-06 07:00:00	QQQ	ETF	42.52	42.62	42.48	42.55	809887.0
2007-03-06 08:00:00	QQQ	ETF	42.56	42.58	42.43	42.54	3189408.0
2007-03-06 09:00:00	QQQ	ETF	42.55	42.72	42.5	42.63	27469619.0
2007-03-06 10:00:00	QQQ	ETF	42.62	42.66	42.5	42.53	31125600.0
2007-03-06 11:00:00	QQQ	ETF	42.53	42.7	42.51	42.69	16234100.0
2007-03-06 12:00:00	QQQ	ETF	42.68	42.77	42.64	42.73	11271500.0
2007-03-06 13:00:00	QQQ	ETF	42.73	42.83	42.69	42.81	12253000.0
2007-03-06 14:00:00	QQQ	ETF	42.81	42.88	42.75	42.87	11457800.0
2007-03-06 15:00:00	QQQ	ETF	42.87	42.99	42.83	42.86	28914000.0
2007-03-06 16:00:00	QQQ	ETF	42.86	42.9	42.84	42.88	4336877.0
2007-03-06 17:00:00	QQQ	ETF	42.88	42.92	42.87	42.9	112792.0
2007-03-06 18:00:00	QQQ	ETF	42.9	42.92	42.89	42.91	59951.0
2007-03-06 19:00:00	QQQ	ETF	42.92	42.94	42.91	42.92	78290.0
2007-03-06 07:00:00	IWM	ETF	76.37	76.37	76.07	76.25	25200.0
2007-03-06 08:00:00	IWM	ETF	76.28	76.44	76.08	76.33	2781200.0
2007-03-06 09:00:00	IWM	ETF	76.31	76.78	76.15	76.64	14932700.0
2007-03-06 10:00:00	IWM	ETF	76.64	76.77	76.19	76.27	17153500.0
2007-03-06 11:00:00	IWM	ETF	76.27	76.77	76.26	76.75	7903600.0
2007-03-06 12:00:00	IWM	ETF	76.75	77.04	76.66	77.02	10091200.0
2007-03-06 13:00:00	IWM	ETF	77.03	77.27	76.94	77.21	8598900.0
2007-03-06 14:00:00	IWM	ETF	77.22	77.5	77.1396	77.49	12030800.0
2007-03-06 15:00:00	IWM	ETF	77.48	77.71	77.28	77.4	13192615.0
2007-03-06 16:00:00	IWM	ETF	77.38	77.38	77.16	77.23	1637200.0
2007-03-06 17:00:00	IWM	ETF	77.18	77.23	77.18	77.2	1400.0
2007-03-06 07:00:00	DIA	ETF	121.38	121.4	121.32	121.39	19500.0
2007-03-06 08:00:00	DIA	ETF	121.34	121.38	121.01	121.24	171600.0
2007-03-06 09:00:00	DIA	ETF	121.21	121.59	121.18	121.44	1345900.0
2007-03-06 10:00:00	DIA	ETF	121.44	121.5	120.98	121.02	1728700.0
2007-03-06 11:00:00	DIA	ETF	121.03	121.61	121.02	121.47	749700.0
2007-03-06 12:00:00	DIA	ETF	121.49	121.61	121.32	121.56	1161900.0
2007-03-06 13:00:00	DIA	ETF	121.56	121.85	121.44	121.74	1116500.0
2007-03-06 14:00:00	DIA	ETF	121.75	122.05	121.64	122.05	836700.0
2007-03-06 15:00:00	DIA	ETF	122.04	122.29	121.96	122.1	1811000.0

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

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