PREVIEW / etf_1hour / 2008-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-16.parquet
  size:    106 KB
  rows:    3,396

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
2008-05-16 04:00:00	SPY	ETF	142.53	142.68	142.53	142.68	1300.0
2008-05-16 05:00:00	SPY	ETF	142.9	142.95	142.9	142.95	12600.0
2008-05-16 06:00:00	SPY	ETF	142.94	143.03	142.89	142.98	108700.0
2008-05-16 07:00:00	SPY	ETF	143.0	143.0	142.75	142.77	481560.0
2008-05-16 08:00:00	SPY	ETF	142.77	143.03	142.66	142.96	3046220.0
2008-05-16 09:00:00	SPY	ETF	142.98	142.98	142.3	142.35	26195379.0
2008-05-16 10:00:00	SPY	ETF	142.36	142.5397	141.79	141.81	54747726.0
2008-05-16 11:00:00	SPY	ETF	141.81	142.07	141.61	141.91	22587079.0
2008-05-16 12:00:00	SPY	ETF	141.9	142.31	141.78	142.2399	15092226.0
2008-05-16 13:00:00	SPY	ETF	142.22	142.38	141.97	142.17	19559992.0
2008-05-16 14:00:00	SPY	ETF	142.17	142.7317	141.99	142.44	24058631.0
2008-05-16 15:00:00	SPY	ETF	142.44	142.8	142.23	142.65	29225587.0
2008-05-16 16:00:00	SPY	ETF	142.69	142.77	142.0	142.66	6822990.0
2008-05-16 17:00:00	SPY	ETF	142.66	142.73	142.66	142.69	282900.0
2008-05-16 18:00:00	SPY	ETF	142.69	142.72	142.68	142.72	27100.0
2008-05-16 19:00:00	SPY	ETF	142.72	142.78	142.72	142.76	8005.0
2008-05-16 04:00:00	QQQ	ETF	49.99	50.04	49.98	50.04	300.0
2008-05-16 06:00:00	QQQ	ETF	50.1	50.11	50.1	50.11	1100.0
2008-05-16 07:00:00	QQQ	ETF	50.11	50.13	50.04	50.05	198490.0
2008-05-16 08:00:00	QQQ	ETF	50.04	50.09	49.96	50.04	2519811.0
2008-05-16 09:00:00	QQQ	ETF	50.05	50.11	49.8	49.83	20799723.0
2008-05-16 10:00:00	QQQ	ETF	49.83	49.87	49.57	49.57	21018451.0
2008-05-16 11:00:00	QQQ	ETF	49.57	49.75	49.45	49.7	16888196.0
2008-05-16 12:00:00	QQQ	ETF	49.7	49.88	49.63	49.859	14863556.0
2008-05-16 13:00:00	QQQ	ETF	49.84	49.88	49.59	49.7001	20543850.0
2008-05-16 14:00:00	QQQ	ETF	49.7	49.91	49.65	49.87	11106950.0
2008-05-16 15:00:00	QQQ	ETF	49.8601	50.06	49.79	50.0	21808608.0
2008-05-16 16:00:00	QQQ	ETF	50.0	50.06	49.7757	50.04	4146868.0
2008-05-16 17:00:00	QQQ	ETF	50.04	50.05	50.03	50.04	58205.0
2008-05-16 18:00:00	QQQ	ETF	50.02	50.04	50.02	50.04	15306.0
2008-05-16 19:00:00	QQQ	ETF	50.05	50.07	50.04	50.07	8575.0
2008-05-16 06:00:00	IWM	ETF	74.3	74.3	74.3	74.3	200.0
2008-05-16 07:00:00	IWM	ETF	74.3	74.32	74.3	74.3	1883.0
2008-05-16 08:00:00	IWM	ETF	74.29	74.5	74.2	74.46	218361.0
2008-05-16 09:00:00	IWM	ETF	74.45	74.52	73.74	73.75	8740460.0
2008-05-16 10:00:00	IWM	ETF	73.76	73.81	73.3	73.31	12616677.0
2008-05-16 11:00:00	IWM	ETF	73.3	73.46	73.09	73.41	7812873.0
2008-05-16 12:00:00	IWM	ETF	73.41	73.7	73.29	73.63	6923962.0
2008-05-16 13:00:00	IWM	ETF	73.63	73.69	73.42	73.54	6516854.0
2008-05-16 14:00:00	IWM	ETF	73.53	73.94	73.44	73.87	6781458.0
2008-05-16 15:00:00	IWM	ETF	73.87	74.05	73.77	73.92	9022100.0
2008-05-16 16:00:00	IWM	ETF	73.92	74.21	73.61	74.01	3851516.0
2008-05-16 17:00:00	IWM	ETF	74.02	74.18	74.01	74.05	32600.0
2008-05-16 18:00:00	IWM	ETF	74.02	74.02	74.02	74.02	200.0
2008-05-16 07:00:00	DIA	ETF	130.42	130.42	130.01	130.01	155225.0
2008-05-16 08:00:00	DIA	ETF	129.95	130.16	129.86	130.16	135335.0
2008-05-16 09:00:00	DIA	ETF	130.16	130.16	129.59	129.62	1242171.0
2008-05-16 10:00:00	DIA	ETF	129.63	129.66	129.11	129.12	1722153.0
2008-05-16 11:00:00	DIA	ETF	129.12	129.19	128.8	128.99	1725372.0
2008-05-16 12:00:00	DIA	ETF	128.99	129.4	128.89	129.35	972853.0

> showing 50 of 3,396 rows — these rows as CSV

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