PREVIEW / etf_1hour / 2009-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-23.parquet
  size:    138 KB
  rows:    4,255

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
2009-06-23 04:00:00	SPY	ETF	89.38	89.74	89.38	89.74	1550.0
2009-06-23 05:00:00	SPY	ETF	89.74	89.76	89.62	89.62	1725.0
2009-06-23 06:00:00	SPY	ETF	89.7	89.8	89.63	89.7	78629.0
2009-06-23 07:00:00	SPY	ETF	89.66	89.71	89.52	89.56	294329.0
2009-06-23 08:00:00	SPY	ETF	89.56	89.85	89.0	89.66	2391504.0
2009-06-23 09:00:00	SPY	ETF	89.66	89.81	89.35	89.75	24602517.0
2009-06-23 10:00:00	SPY	ETF	89.76	89.88	88.95	89.1806	41176890.0
2009-06-23 11:00:00	SPY	ETF	89.18	89.46	88.85	89.42	22048196.0
2009-06-23 12:00:00	SPY	ETF	89.42	89.6	89.2	89.41	20779618.0
2009-06-23 13:00:00	SPY	ETF	89.41	89.75	89.1	89.27	21113096.0
2009-06-23 14:00:00	SPY	ETF	89.27	89.72	89.21	89.47	18454287.0
2009-06-23 15:00:00	SPY	ETF	89.47	89.77	89.24	89.43	29732941.0
2009-06-23 16:00:00	SPY	ETF	89.43	89.75	89.0	89.42	6172627.0
2009-06-23 17:00:00	SPY	ETF	89.4	89.5106	89.36	89.5	335135.0
2009-06-23 18:00:00	SPY	ETF	89.47	89.47	89.36	89.43	61401.0
2009-06-23 19:00:00	SPY	ETF	89.43	89.44	89.32	89.44	108302.0
2009-06-23 04:00:00	QQQ	ETF	35.17	35.26	35.17	35.26	5497.0
2009-06-23 05:00:00	QQQ	ETF	35.29	35.3	35.25	35.25	300.0
2009-06-23 06:00:00	QQQ	ETF	35.26	35.28	35.25	35.25	600.0
2009-06-23 07:00:00	QQQ	ETF	35.26	35.29	35.21	35.24	248225.0
2009-06-23 08:00:00	QQQ	ETF	35.26	35.31	35.23	35.26	437847.0
2009-06-23 09:00:00	QQQ	ETF	35.27	35.27	34.92	35.05	20288754.0
2009-06-23 10:00:00	QQQ	ETF	35.05	35.12	34.79	34.89	24576911.0
2009-06-23 11:00:00	QQQ	ETF	34.88	35.02	34.77	35.01	11073775.0
2009-06-23 12:00:00	QQQ	ETF	35.02	35.04	34.86	34.94	10616073.0
2009-06-23 13:00:00	QQQ	ETF	34.95	35.09	34.91	34.92	10297672.0
2009-06-23 14:00:00	QQQ	ETF	34.91	35.15	34.89	35.08	9726750.0
2009-06-23 15:00:00	QQQ	ETF	35.08	35.17	35.0	35.02	14662056.0
2009-06-23 16:00:00	QQQ	ETF	35.02	35.0882	34.88	35.07	6297798.0
2009-06-23 17:00:00	QQQ	ETF	35.06	35.08	35.0	35.07	287412.0
2009-06-23 18:00:00	QQQ	ETF	35.06	35.06	35.05	35.05	12550.0
2009-06-23 19:00:00	QQQ	ETF	35.06	35.07	35.05	35.07	7200.0
2009-06-23 06:00:00	IWM	ETF	49.92	49.92	49.89	49.89	484.0
2009-06-23 07:00:00	IWM	ETF	49.83	49.91	49.81	49.85	8100.0
2009-06-23 08:00:00	IWM	ETF	49.82	49.99	49.79	49.89	132368.0
2009-06-23 09:00:00	IWM	ETF	49.87	49.94	49.48	49.69	5771382.0
2009-06-23 10:00:00	IWM	ETF	49.68	49.8	49.11	49.242	6552899.0
2009-06-23 11:00:00	IWM	ETF	49.24	49.34	49.02	49.33	4796660.0
2009-06-23 12:00:00	IWM	ETF	49.34	49.4	49.12	49.25	4092623.0
2009-06-23 13:00:00	IWM	ETF	49.26	49.47	49.06	49.06	3862125.0
2009-06-23 14:00:00	IWM	ETF	49.07	49.38	49.02	49.25	3507339.0
2009-06-23 15:00:00	IWM	ETF	49.235	49.35	49.06	49.12	5930687.0
2009-06-23 16:00:00	IWM	ETF	49.12	49.17	48.9	49.09	2507770.0
2009-06-23 17:00:00	IWM	ETF	49.1	49.1	49.0	49.08	7300.0
2009-06-23 18:00:00	IWM	ETF	49.08	49.1	49.08	49.1	2583.0
2009-06-23 19:00:00	IWM	ETF	49.12	49.14	49.1	49.14	1450.0
2009-06-23 06:00:00	DIA	ETF	83.72	83.72	83.72	83.72	300.0
2009-06-23 07:00:00	DIA	ETF	83.58	83.72	83.56	83.63	8121.0
2009-06-23 08:00:00	DIA	ETF	83.6	83.82	83.6	83.69	45937.0
2009-06-23 09:00:00	DIA	ETF	83.68	83.8	83.27	83.62	1746386.0

> showing 50 of 4,255 rows — these rows as CSV

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