PREVIEW / etf_1hour / 2009-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-17.parquet
  size:    145 KB
  rows:    4,462

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-09-17 04:00:00	SPY	ETF	107.56	107.56	107.21	107.21	3830.0
2009-09-17 05:00:00	SPY	ETF	107.23	107.5	107.23	107.5	11390.0
2009-09-17 06:00:00	SPY	ETF	107.5	107.54	107.45	107.52	21150.0
2009-09-17 07:00:00	SPY	ETF	107.54	107.54	107.18	107.2	264911.0
2009-09-17 08:00:00	SPY	ETF	107.24	107.43	107.04	107.06	3432162.0
2009-09-17 09:00:00	SPY	ETF	107.06	108.81	106.97	107.85	24991604.0
2009-09-17 10:00:00	SPY	ETF	107.85	108.06	107.2	107.62	40701473.0
2009-09-17 11:00:00	SPY	ETF	107.63	107.84	107.25	107.38	23525536.0
2009-09-17 12:00:00	SPY	ETF	107.38	107.56	106.69	106.72	27139788.0
2009-09-17 13:00:00	SPY	ETF	106.72	107.11	106.57	107.06	22409506.0
2009-09-17 14:00:00	SPY	ETF	107.06	107.35	106.93	107.2206	18524851.0
2009-09-17 15:00:00	SPY	ETF	107.23	107.4	106.88	107.15	27682979.0
2009-09-17 16:00:00	SPY	ETF	107.16	108.8	106.7311	107.23	28724137.0
2009-09-17 17:00:00	SPY	ETF	107.24	107.3557	107.14	107.22	1172646.0
2009-09-17 18:00:00	SPY	ETF	107.22	107.22	107.14	107.14	844276.0
2009-09-17 19:00:00	SPY	ETF	107.14	107.14	107.02	107.02	57990.0
2009-09-17 05:00:00	QQQ	ETF	42.45	42.45	42.45	42.45	5500.0
2009-09-17 06:00:00	QQQ	ETF	42.44	42.44	42.42	42.44	1266.0
2009-09-17 07:00:00	QQQ	ETF	42.41	42.41	42.29	42.29	109354.0
2009-09-17 08:00:00	QQQ	ETF	42.29	42.38	42.22	42.23	673507.0
2009-09-17 09:00:00	QQQ	ETF	42.24	42.91	42.21	42.5299	13084179.0
2009-09-17 10:00:00	QQQ	ETF	42.53	42.65	42.4	42.58	21592848.0
2009-09-17 11:00:00	QQQ	ETF	42.58	42.66	42.44	42.5	12390799.0
2009-09-17 12:00:00	QQQ	ETF	42.5	42.5201	42.22	42.24	14184551.0
2009-09-17 13:00:00	QQQ	ETF	42.23	42.43	42.21	42.41	7426580.0
2009-09-17 14:00:00	QQQ	ETF	42.41	42.49	42.36	42.47	9893214.0
2009-09-17 15:00:00	QQQ	ETF	42.47	42.51	42.33	42.41	13095943.0
2009-09-17 16:00:00	QQQ	ETF	42.41	42.62	42.34	42.4	1707100.0
2009-09-17 17:00:00	QQQ	ETF	42.4	42.42	42.39	42.4	17867.0
2009-09-17 18:00:00	QQQ	ETF	42.42	42.42	42.38	42.38	11700.0
2009-09-17 19:00:00	QQQ	ETF	42.38	42.39	42.34	42.37	23276.0
2009-09-17 07:00:00	IWM	ETF	61.94	61.96	61.78	61.79	155070.0
2009-09-17 08:00:00	IWM	ETF	61.79	62.0	61.66	61.68	761532.0
2009-09-17 09:00:00	IWM	ETF	61.68	62.2	61.65	62.18	5728984.0
2009-09-17 10:00:00	IWM	ETF	62.19	62.34	61.88	62.158	10848072.0
2009-09-17 11:00:00	IWM	ETF	62.15	62.25	61.92	62.02	5175259.0
2009-09-17 12:00:00	IWM	ETF	62.01	62.03	61.43	61.46	7667104.0
2009-09-17 13:00:00	IWM	ETF	61.45	61.68	61.35	61.64	4668135.0
2009-09-17 14:00:00	IWM	ETF	61.64	61.84	61.53	61.77	4421691.0
2009-09-17 15:00:00	IWM	ETF	61.77	61.81	61.48	61.69	7229164.0
2009-09-17 16:00:00	IWM	ETF	61.68	61.8486	61.64	61.74	2039742.0
2009-09-17 17:00:00	IWM	ETF	61.78	61.8	61.72	61.8	4498.0
2009-09-17 18:00:00	IWM	ETF	61.7	61.7	61.7	61.7	300.0
2009-09-17 19:00:00	IWM	ETF	61.75	61.75	61.72	61.72	1300.0
2009-09-17 06:00:00	DIA	ETF	98.26	98.26	98.26	98.26	100.0
2009-09-17 07:00:00	DIA	ETF	98.2	98.2	98.05	98.05	400.0
2009-09-17 08:00:00	DIA	ETF	98.06	98.21	97.91	97.92	50332.0
2009-09-17 09:00:00	DIA	ETF	97.93	98.51	97.86	98.51	1156171.0
2009-09-17 10:00:00	DIA	ETF	98.52	98.72	98.0213	98.38	2883515.0
2009-09-17 11:00:00	DIA	ETF	98.389	98.55	98.08	98.179	1971377.0

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

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