PREVIEW / etf_1hour / 2009-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-20.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-05-20 04:00:00	SPY	ETF	91.67	91.67	91.57	91.65	11950.0
2009-05-20 05:00:00	SPY	ETF	91.5	91.6	91.33	91.36	8140.0
2009-05-20 06:00:00	SPY	ETF	91.38	91.6	91.2	91.5	25900.0
2009-05-20 07:00:00	SPY	ETF	91.52	91.75	91.3	91.59	781612.0
2009-05-20 08:00:00	SPY	ETF	91.59	91.82	90.6	91.78	2381390.0
2009-05-20 09:00:00	SPY	ETF	91.79	92.56	91.12	92.41	31717952.0
2009-05-20 10:00:00	SPY	ETF	92.3999	92.8	92.32	92.35	37629705.0
2009-05-20 11:00:00	SPY	ETF	92.35	92.44	91.55	91.58	37311983.0
2009-05-20 12:00:00	SPY	ETF	91.58	91.73	91.24	91.26	28435067.0
2009-05-20 13:00:00	SPY	ETF	91.26	91.83	91.17	91.74	27288432.0
2009-05-20 14:00:00	SPY	ETF	91.75	91.92	91.29	91.67	45890856.0
2009-05-20 15:00:00	SPY	ETF	91.68	91.69	90.41	90.57	57078384.0
2009-05-20 16:00:00	SPY	ETF	90.55	92.05	90.37	90.54	15732678.0
2009-05-20 17:00:00	SPY	ETF	90.53	90.55	90.37	90.42	560517.0
2009-05-20 18:00:00	SPY	ETF	90.42	90.54	90.33	90.35	333310.0
2009-05-20 19:00:00	SPY	ETF	90.34	90.46	90.25	90.39	118303.0
2009-05-20 05:00:00	QQQ	ETF	34.44	34.44	34.37	34.38	2200.0
2009-05-20 06:00:00	QQQ	ETF	34.41	34.42	34.34	34.41	1000.0
2009-05-20 07:00:00	QQQ	ETF	34.39	34.49	34.35	34.41	202832.0
2009-05-20 08:00:00	QQQ	ETF	34.0	34.56	34.0	34.51	1712106.0
2009-05-20 09:00:00	QQQ	ETF	34.51	34.87	34.46	34.8	14723052.0
2009-05-20 10:00:00	QQQ	ETF	34.81	35.04	34.8	34.92	15951984.0
2009-05-20 11:00:00	QQQ	ETF	34.92	34.97	34.65	34.67	13233607.0
2009-05-20 12:00:00	QQQ	ETF	34.67	34.74	34.4	34.41	11024539.0
2009-05-20 13:00:00	QQQ	ETF	34.42	34.66	34.36	34.66	16243713.0
2009-05-20 14:00:00	QQQ	ETF	34.66	34.76	34.48	34.68	21418329.0
2009-05-20 15:00:00	QQQ	ETF	34.68	34.688	34.18	34.29	27977652.0
2009-05-20 16:00:00	QQQ	ETF	34.29	34.6209	34.15	34.32	3746923.0
2009-05-20 17:00:00	QQQ	ETF	34.32	34.32	34.23	34.25	28413.0
2009-05-20 18:00:00	QQQ	ETF	34.27	34.28	34.21	34.24	31076.0
2009-05-20 19:00:00	QQQ	ETF	34.22	34.26	34.19	34.25	45100.0
2009-05-20 06:00:00	IWM	ETF	49.44	49.44	49.4	49.4	3000.0
2009-05-20 07:00:00	IWM	ETF	49.53	49.7	49.53	49.59	17460.0
2009-05-20 08:00:00	IWM	ETF	49.61	49.83	49.55	49.74	103140.0
2009-05-20 09:00:00	IWM	ETF	49.74	50.295	49.38	50.25	4275075.0
2009-05-20 10:00:00	IWM	ETF	50.26	50.69	50.26	50.37	6057488.0
2009-05-20 11:00:00	IWM	ETF	50.37	50.47	49.82	49.83	5666469.0
2009-05-20 12:00:00	IWM	ETF	49.82	49.94	49.44	49.45	3989990.0
2009-05-20 13:00:00	IWM	ETF	49.45	49.81	49.31	49.75	7433241.0
2009-05-20 14:00:00	IWM	ETF	49.75	49.9	49.45	49.7	7107537.0
2009-05-20 15:00:00	IWM	ETF	49.7	49.73	48.85	48.96	11225129.0
2009-05-20 16:00:00	IWM	ETF	48.96	49.7433	48.87	48.9	1042340.0
2009-05-20 17:00:00	IWM	ETF	48.87	48.94	48.83	48.86	50707.0
2009-05-20 18:00:00	IWM	ETF	48.87	48.87	48.87	48.87	300.0
2009-05-20 19:00:00	IWM	ETF	48.88	48.94	48.88	48.94	200.0
2009-05-20 06:00:00	DIA	ETF	84.86	85.06	84.84	85.06	6111.0
2009-05-20 07:00:00	DIA	ETF	84.92	85.09	84.91	85.07	3225.0
2009-05-20 08:00:00	DIA	ETF	85.11	85.27	85.09	85.26	50635.0
2009-05-20 09:00:00	DIA	ETF	85.22	85.83	85.2	85.71	1533055.0
2009-05-20 10:00:00	DIA	ETF	85.71	85.97	85.56	85.58	1942480.0

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

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