PREVIEW / etf_1hour / 2007-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-19.parquet
  size:    66 KB
  rows:    2,117

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-19 04:00:00	SPY	ETF	138.8	138.99	138.8	138.99	1200.0
2007-03-19 06:00:00	SPY	ETF	139.38	139.38	139.22	139.22	30900.0
2007-03-19 07:00:00	SPY	ETF	139.22	139.34	139.22	139.24	589100.0
2007-03-19 08:00:00	SPY	ETF	139.25	139.36	139.2	139.28	1337800.0
2007-03-19 09:00:00	SPY	ETF	139.29	139.66	138.55	139.41	14484293.0
2007-03-19 10:00:00	SPY	ETF	139.41	139.9	139.15	139.82	17010945.0
2007-03-19 11:00:00	SPY	ETF	139.82	140.18	139.75	140.08	14594400.0
2007-03-19 12:00:00	SPY	ETF	140.09	140.2	139.79	139.88	7062466.0
2007-03-19 13:00:00	SPY	ETF	139.88	140.1	139.75	140.03	6877550.0
2007-03-19 14:00:00	SPY	ETF	140.04	140.15	139.83	140.03	9496600.0
2007-03-19 15:00:00	SPY	ETF	140.04	140.33	139.75	140.07	11597900.0
2007-03-19 16:00:00	SPY	ETF	140.07	140.23	139.98	140.2	9104300.0
2007-03-19 17:00:00	SPY	ETF	140.2	140.31	140.17	140.31	204100.0
2007-03-19 18:00:00	SPY	ETF	140.32	140.32	140.21	140.25	131800.0
2007-03-19 19:00:00	SPY	ETF	140.22	140.26	140.22	140.23	5100.0
2007-03-19 04:00:00	QQQ	ETF	43.03	43.03	43.03	43.03	200.0
2007-03-19 07:00:00	QQQ	ETF	43.06	43.1	43.04	43.08	214244.0
2007-03-19 08:00:00	QQQ	ETF	43.07	43.11	43.05	43.09	756112.0
2007-03-19 09:00:00	QQQ	ETF	43.08	43.15	43.02	43.08	13837595.0
2007-03-19 10:00:00	QQQ	ETF	43.07	43.25	42.95	43.23	15566900.0
2007-03-19 11:00:00	QQQ	ETF	43.23	43.39	43.21	43.35	14334900.0
2007-03-19 12:00:00	QQQ	ETF	43.34	43.35	43.16	43.2	8906600.0
2007-03-19 13:00:00	QQQ	ETF	43.19	43.28	43.12	43.25	7583300.0
2007-03-19 14:00:00	QQQ	ETF	43.24	43.28	43.17	43.2	10213200.0
2007-03-19 15:00:00	QQQ	ETF	43.2	43.22	43.07	43.21	14757900.0
2007-03-19 16:00:00	QQQ	ETF	43.21	43.37	43.195	43.31	7796764.0
2007-03-19 17:00:00	QQQ	ETF	43.3	43.35	43.3	43.35	54681.0
2007-03-19 18:00:00	QQQ	ETF	43.35	43.35	43.3	43.3	45906.0
2007-03-19 19:00:00	QQQ	ETF	43.33	43.35	43.31	43.35	14644.0
2007-03-19 07:00:00	IWM	ETF	77.49	77.97	77.49	77.97	1700.0
2007-03-19 08:00:00	IWM	ETF	77.9	77.9	77.79	77.86	165400.0
2007-03-19 09:00:00	IWM	ETF	77.85	78.11	77.8	78.03	6294800.0
2007-03-19 10:00:00	IWM	ETF	78.03	78.39	77.88	78.32	10813600.0
2007-03-19 11:00:00	IWM	ETF	78.32	78.48	78.22	78.44	10876805.0
2007-03-19 12:00:00	IWM	ETF	78.44	78.46	78.18	78.25	4302800.0
2007-03-19 13:00:00	IWM	ETF	78.25	78.43	78.13	78.35	5628410.0
2007-03-19 14:00:00	IWM	ETF	78.35	78.45	78.08	78.15	5147800.0
2007-03-19 15:00:00	IWM	ETF	78.15	78.2	77.99	78.19	9662439.0
2007-03-19 16:00:00	IWM	ETF	78.18	78.31	78.0935	78.24	2934800.0
2007-03-19 17:00:00	IWM	ETF	78.24	78.25	78.22	78.25	9200.0
2007-03-19 18:00:00	IWM	ETF	78.25	78.25	78.25	78.25	1300.0
2007-03-19 19:00:00	IWM	ETF	78.25	78.25	78.25	78.25	400.0
2007-03-19 07:00:00	DIA	ETF	121.63	121.65	121.54	121.54	4100.0
2007-03-19 08:00:00	DIA	ETF	121.58	121.63	121.53	121.57	112000.0
2007-03-19 09:00:00	DIA	ETF	121.59	121.9	121.56	121.7	1425228.0
2007-03-19 10:00:00	DIA	ETF	121.69	122.05	121.5	121.99	1082500.0
2007-03-19 11:00:00	DIA	ETF	121.98	122.21	121.92	122.15	1429800.0
2007-03-19 12:00:00	DIA	ETF	122.14	122.23	121.98	122.0315	539400.0
2007-03-19 13:00:00	DIA	ETF	122.03	122.19	121.94	122.1	533600.0
2007-03-19 14:00:00	DIA	ETF	122.11	122.2	121.95	122.12	526400.0

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

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