PREVIEW / etf_1hour / 2009-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-15.parquet
  size:    139 KB
  rows:    4,307

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-15 05:00:00	SPY	ETF	93.78	93.85	93.68	93.85	13500.0
2009-06-15 06:00:00	SPY	ETF	93.84	94.02	93.84	93.87	29050.0
2009-06-15 07:00:00	SPY	ETF	93.84	93.96	93.73	93.83	1191537.0
2009-06-15 08:00:00	SPY	ETF	93.84	94.5129	93.66	93.96	3132222.0
2009-06-15 09:00:00	SPY	ETF	93.96	94.02	93.2	93.59	36572198.0
2009-06-15 10:00:00	SPY	ETF	93.59	93.63	92.72	92.92	38727302.0
2009-06-15 11:00:00	SPY	ETF	92.92	93.75	92.56	92.76	24948519.0
2009-06-15 12:00:00	SPY	ETF	92.76	92.85	92.55	92.81	17923473.0
2009-06-15 13:00:00	SPY	ETF	92.8	92.84	92.42	92.59	20378407.0
2009-06-15 14:00:00	SPY	ETF	92.58	92.79	92.43	92.6	18448583.0
2009-06-15 15:00:00	SPY	ETF	92.6	93.01	92.45	92.86	46592937.0
2009-06-15 16:00:00	SPY	ETF	92.86	95.0835	92.69	92.8	14037563.0
2009-06-15 17:00:00	SPY	ETF	92.82	95.0835	92.74	92.8	1269826.0
2009-06-15 18:00:00	SPY	ETF	92.8	92.82	92.77	92.82	52496.0
2009-06-15 19:00:00	SPY	ETF	92.8	92.85	92.73	92.84	25981.0
2009-06-15 05:00:00	QQQ	ETF	36.17	36.17	36.16	36.16	8000.0
2009-06-15 07:00:00	QQQ	ETF	36.22	36.29	36.2	36.22	187806.0
2009-06-15 08:00:00	QQQ	ETF	36.23	36.35	36.2	36.29	727582.0
2009-06-15 09:00:00	QQQ	ETF	36.29	36.33	35.96	36.04	21167344.0
2009-06-15 10:00:00	QQQ	ETF	36.03	36.08	35.63	35.71	22738300.0
2009-06-15 11:00:00	QQQ	ETF	35.71	35.74	35.58	35.681	12380284.0
2009-06-15 12:00:00	QQQ	ETF	35.68	35.79	35.64	35.77	7729453.0
2009-06-15 13:00:00	QQQ	ETF	35.77	35.8	35.59	35.7	8811676.0
2009-06-15 14:00:00	QQQ	ETF	35.7	35.82	35.65	35.74	7530411.0
2009-06-15 15:00:00	QQQ	ETF	35.73	35.93	35.67	35.9	21873708.0
2009-06-15 16:00:00	QQQ	ETF	35.9	35.92	35.6691	35.9	6511781.0
2009-06-15 17:00:00	QQQ	ETF	35.91	36.6924	35.84	35.86	1018867.0
2009-06-15 18:00:00	QQQ	ETF	35.88	35.9	35.86	35.88	13928.0
2009-06-15 19:00:00	QQQ	ETF	35.88	35.88	35.85	35.87	43390.0
2009-06-15 07:00:00	IWM	ETF	51.99	52.02	51.93	51.99	28300.0
2009-06-15 08:00:00	IWM	ETF	51.97	52.07	51.88	52.02	189860.0
2009-06-15 09:00:00	IWM	ETF	52.02	52.09	51.24	51.48	9285976.0
2009-06-15 10:00:00	IWM	ETF	51.48	51.48	50.82	51.002	8538944.0
2009-06-15 11:00:00	IWM	ETF	51.0	51.14	50.86	50.9822	4022479.0
2009-06-15 12:00:00	IWM	ETF	50.98	51.12	50.85	51.09	3676854.0
2009-06-15 13:00:00	IWM	ETF	51.09	51.14	50.8	50.9681	3035737.0
2009-06-15 14:00:00	IWM	ETF	50.96	51.11	50.89	51.02	3011437.0
2009-06-15 15:00:00	IWM	ETF	51.01	51.4	50.93	51.38	9286456.0
2009-06-15 16:00:00	IWM	ETF	51.37	51.43	51.1134	51.42	2763543.0
2009-06-15 17:00:00	IWM	ETF	51.4	51.42	51.38	51.38	9691.0
2009-06-15 19:00:00	IWM	ETF	51.37	51.37	51.32	51.32	1000.0
2009-06-15 07:00:00	DIA	ETF	87.13	87.28	87.13	87.2	4300.0
2009-06-15 08:00:00	DIA	ETF	87.18	87.37	87.11	87.24	61880.0
2009-06-15 09:00:00	DIA	ETF	87.24	87.28	86.6	86.9	2018121.0
2009-06-15 10:00:00	DIA	ETF	86.89	86.91	86.07	86.29	2932019.0
2009-06-15 11:00:00	DIA	ETF	86.3	86.38	86.02	86.23	1621070.0
2009-06-15 12:00:00	DIA	ETF	86.23	86.39	86.09	86.3502	976239.0
2009-06-15 13:00:00	DIA	ETF	86.35	86.37	86.02	86.15	858256.0
2009-06-15 14:00:00	DIA	ETF	86.15	86.34	86.0	86.17	890059.0
2009-06-15 15:00:00	DIA	ETF	86.18	86.5	86.01	86.4	2400610.0

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

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