PREVIEW / etf_1hour / 2009-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-23.parquet
  size:    135 KB
  rows:    4,176

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-03-23 04:00:00	SPY	ETF	78.95	78.98	78.75	78.85	43370.0
2009-03-23 05:00:00	SPY	ETF	78.98	79.03	78.8	78.87	13330.0
2009-03-23 06:00:00	SPY	ETF	79.0	79.16	78.85	79.04	273332.0
2009-03-23 07:00:00	SPY	ETF	79.0	79.37	78.83	79.35	2013291.0
2009-03-23 08:00:00	SPY	ETF	79.35	79.42	77.7276	78.49	8189140.0
2009-03-23 09:00:00	SPY	ETF	78.5	79.11	78.25	78.81	35933909.0
2009-03-23 10:00:00	SPY	ETF	78.81	80.0	78.8001	79.95	70444157.0
2009-03-23 11:00:00	SPY	ETF	79.95	80.42	79.64	80.31	43833929.0
2009-03-23 12:00:00	SPY	ETF	80.31	80.4	80.06	80.07	29521032.0
2009-03-23 13:00:00	SPY	ETF	80.07	80.53	79.6	79.77	40577639.0
2009-03-23 14:00:00	SPY	ETF	79.769	80.96	79.63	80.9	45368611.0
2009-03-23 15:00:00	SPY	ETF	80.91	82.27	80.69	82.27	102195200.0
2009-03-23 16:00:00	SPY	ETF	82.25	82.42	76.8226	82.15	29078245.0
2009-03-23 17:00:00	SPY	ETF	82.16	82.25	82.1	82.16	7853873.0
2009-03-23 18:00:00	SPY	ETF	82.17	82.22	81.99	82.02	167746.0
2009-03-23 19:00:00	SPY	ETF	82.02	82.02	81.91	81.99	175453.0
2009-03-23 04:00:00	QQQ	ETF	29.97	29.97	29.94	29.94	1200.0
2009-03-23 05:00:00	QQQ	ETF	30.0	30.0	29.96	30.0	4500.0
2009-03-23 06:00:00	QQQ	ETF	30.0	30.04	29.97	30.0	35000.0
2009-03-23 07:00:00	QQQ	ETF	29.97	30.1	29.9	30.05	1517396.0
2009-03-23 08:00:00	QQQ	ETF	30.05	30.12	29.5048	29.8	4379151.0
2009-03-23 09:00:00	QQQ	ETF	29.82	29.92	29.61	29.79	16272875.0
2009-03-23 10:00:00	QQQ	ETF	29.8	30.2	29.8	30.1599	23998305.0
2009-03-23 11:00:00	QQQ	ETF	30.15	30.42	30.11	30.38	15738623.0
2009-03-23 12:00:00	QQQ	ETF	30.39	30.43	30.27	30.2701	10762625.0
2009-03-23 13:00:00	QQQ	ETF	30.27	30.38	29.1984	30.17	14539498.0
2009-03-23 14:00:00	QQQ	ETF	30.17	30.55	30.11	30.539	16850186.0
2009-03-23 15:00:00	QQQ	ETF	30.53	30.94	30.46	30.94	49936543.0
2009-03-23 16:00:00	QQQ	ETF	30.94	30.95	30.79	30.86	13497080.0
2009-03-23 17:00:00	QQQ	ETF	30.82	30.89	30.82	30.88	1771211.0
2009-03-23 18:00:00	QQQ	ETF	30.88	30.89	30.81	30.81	97176.0
2009-03-23 19:00:00	QQQ	ETF	30.81	30.81	30.76	30.8	79404.0
2009-03-23 04:00:00	IWM	ETF	41.0	41.0	41.0	41.0	500.0
2009-03-23 05:00:00	IWM	ETF	41.2	41.2	41.2	41.2	100.0
2009-03-23 06:00:00	IWM	ETF	41.25	41.37	41.25	41.37	300.0
2009-03-23 07:00:00	IWM	ETF	41.32	41.52	41.24	41.51	51963.0
2009-03-23 08:00:00	IWM	ETF	41.52	41.56	41.05	41.05	216963.0
2009-03-23 09:00:00	IWM	ETF	41.08	41.44	40.93	41.275	6746322.0
2009-03-23 10:00:00	IWM	ETF	41.28	41.91	41.28	41.85	11146323.0
2009-03-23 11:00:00	IWM	ETF	41.85	42.201	41.78	42.15	8425414.0
2009-03-23 12:00:00	IWM	ETF	42.15	42.23	42.0	42.0095	5556412.0
2009-03-23 13:00:00	IWM	ETF	42.0	42.2	41.69	41.82	6828429.0
2009-03-23 14:00:00	IWM	ETF	41.82	42.38	41.7	42.35	10402683.0
2009-03-23 15:00:00	IWM	ETF	42.36	43.43	42.22	43.41	30565836.0
2009-03-23 16:00:00	IWM	ETF	43.42	43.75	40.0985	43.24	6596841.0
2009-03-23 17:00:00	IWM	ETF	43.31	43.38	43.28	43.38	64917.0
2009-03-23 18:00:00	IWM	ETF	43.5	43.5	43.16	43.21	1150.0
2009-03-23 19:00:00	IWM	ETF	43.38	43.38	43.34	43.35	350.0
2009-03-23 06:00:00	DIA	ETF	74.62	74.78	74.62	74.78	1100.0
2009-03-23 07:00:00	DIA	ETF	74.66	74.96	74.56	74.96	38763.0

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

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