PREVIEW / etf_1hour / 2009-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-18.parquet
  size:    136 KB
  rows:    4,166

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-18 04:00:00	SPY	ETF	91.71	91.71	91.5	91.56	4300.0
2009-06-18 05:00:00	SPY	ETF	91.65	91.68	91.57	91.62	26200.0
2009-06-18 06:00:00	SPY	ETF	91.67	91.67	91.28	91.33	22600.0
2009-06-18 07:00:00	SPY	ETF	91.31	91.69	91.25	91.29	633062.0
2009-06-18 08:00:00	SPY	ETF	91.29	91.86	91.23	91.74	4826315.0
2009-06-18 09:00:00	SPY	ETF	91.75	92.28	91.25	92.21	30068268.0
2009-06-18 10:00:00	SPY	ETF	92.21	92.53	91.99	92.08	39153573.0
2009-06-18 11:00:00	SPY	ETF	92.08	92.39	92.05	92.3	17650234.0
2009-06-18 12:00:00	SPY	ETF	92.3099	92.49	92.16	92.48	13256923.0
2009-06-18 13:00:00	SPY	ETF	92.48	92.67	92.37	92.39	18999876.0
2009-06-18 14:00:00	SPY	ETF	92.39	92.53	92.15	92.47	32787103.0
2009-06-18 15:00:00	SPY	ETF	92.47	92.63	92.02	92.18	35977413.0
2009-06-18 16:00:00	SPY	ETF	92.16	92.58	92.02	92.25	16264483.0
2009-06-18 17:00:00	SPY	ETF	92.25	92.45	92.22	92.45	175847.0
2009-06-18 18:00:00	SPY	ETF	92.44	92.49	92.4	92.45	303571.0
2009-06-18 19:00:00	SPY	ETF	92.44	92.51	92.44	92.49	30919.0
2009-06-18 05:00:00	QQQ	ETF	35.77	35.77	35.77	35.77	100.0
2009-06-18 06:00:00	QQQ	ETF	35.73	35.73	35.65	35.65	5600.0
2009-06-18 07:00:00	QQQ	ETF	35.67	35.83	35.65	35.68	170158.0
2009-06-18 08:00:00	QQQ	ETF	35.68	35.91	35.68	35.88	914145.0
2009-06-18 09:00:00	QQQ	ETF	35.88	35.95	35.57	35.89	23533593.0
2009-06-18 10:00:00	QQQ	ETF	35.89	36.06	35.73	35.79	22269993.0
2009-06-18 11:00:00	QQQ	ETF	35.79	35.86	35.71	35.82	7614741.0
2009-06-18 12:00:00	QQQ	ETF	35.82	36.0	35.79	35.98	7379622.0
2009-06-18 13:00:00	QQQ	ETF	35.99	36.05	35.9	35.94	10199203.0
2009-06-18 14:00:00	QQQ	ETF	35.95	35.96	35.86	35.95	10267517.0
2009-06-18 15:00:00	QQQ	ETF	35.95	36.0	35.76	35.82	20460339.0
2009-06-18 16:00:00	QQQ	ETF	35.82	35.9	35.64	35.73	14275700.0
2009-06-18 17:00:00	QQQ	ETF	35.73	35.93	35.7	35.88	2009636.0
2009-06-18 18:00:00	QQQ	ETF	35.88	35.89	35.85	35.87	417399.0
2009-06-18 19:00:00	QQQ	ETF	35.87	35.9	35.86	35.9	47350.0
2009-06-18 07:00:00	IWM	ETF	50.71	50.73	50.54	50.57	14500.0
2009-06-18 08:00:00	IWM	ETF	50.59	50.92	50.47	50.83	154603.0
2009-06-18 09:00:00	IWM	ETF	50.82	50.92	50.3	50.89	5085838.0
2009-06-18 10:00:00	IWM	ETF	50.88	51.1	50.71	50.8	7246423.0
2009-06-18 11:00:00	IWM	ETF	50.79	51.04	50.79	51.02	3686249.0
2009-06-18 12:00:00	IWM	ETF	51.02	51.2	50.92	51.18	2316255.0
2009-06-18 13:00:00	IWM	ETF	51.18	51.32	51.07	51.07	2900742.0
2009-06-18 14:00:00	IWM	ETF	51.08	51.2	50.94	51.16	4436582.0
2009-06-18 15:00:00	IWM	ETF	51.15	51.262	50.88	51.04	6173761.0
2009-06-18 16:00:00	IWM	ETF	51.04	51.16	50.4	51.07	1095969.0
2009-06-18 17:00:00	IWM	ETF	51.07	51.16	51.06	51.13	9297.0
2009-06-18 18:00:00	IWM	ETF	51.13	51.13	51.09	51.09	1800.0
2009-06-18 07:00:00	DIA	ETF	85.1	85.1	85.0	85.0	700.0
2009-06-18 08:00:00	DIA	ETF	85.06	85.49	85.01	85.4	64987.0
2009-06-18 09:00:00	DIA	ETF	85.45	85.74	84.98	85.63	2141389.0
2009-06-18 10:00:00	DIA	ETF	85.65	86.05	85.64	85.77	2719486.0
2009-06-18 11:00:00	DIA	ETF	85.78	85.97	85.69	85.89	901069.0
2009-06-18 12:00:00	DIA	ETF	85.9	86.0	85.77	85.9797	700771.0
2009-06-18 13:00:00	DIA	ETF	85.99	86.15	85.89	85.9	1014041.0

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

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