PREVIEW / etf_1hour / 2009-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-16.parquet
  size:    138 KB
  rows:    4,210

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-07-16 04:00:00	SPY	ETF	92.65	92.89	92.65	92.89	3700.0
2009-07-16 05:00:00	SPY	ETF	92.77	92.96	92.77	92.96	3600.0
2009-07-16 06:00:00	SPY	ETF	92.83	93.35	92.83	93.26	112435.0
2009-07-16 07:00:00	SPY	ETF	93.18	93.25	92.86	92.86	1027773.0
2009-07-16 08:00:00	SPY	ETF	92.87	93.72	92.87	93.12	9192024.0
2009-07-16 09:00:00	SPY	ETF	93.12	93.55	92.9	93.37	24107099.0
2009-07-16 10:00:00	SPY	ETF	93.37	93.4	92.82	93.19	29701412.0
2009-07-16 11:00:00	SPY	ETF	93.19	93.34	92.93	93.28	14409057.0
2009-07-16 12:00:00	SPY	ETF	93.28	93.36	93.17	93.18	11933647.0
2009-07-16 13:00:00	SPY	ETF	93.18	93.55	93.04	93.55	19875863.0
2009-07-16 14:00:00	SPY	ETF	93.55	94.2	93.47	94.06	40416507.0
2009-07-16 15:00:00	SPY	ETF	94.07	94.51	93.9	94.16	47814639.0
2009-07-16 16:00:00	SPY	ETF	94.16	94.2222	93.3655	93.3655	17716573.0
2009-07-16 17:00:00	SPY	ETF	93.91	93.93	93.75	93.8	398007.0
2009-07-16 18:00:00	SPY	ETF	93.81	93.86	93.11	93.85	64892.0
2009-07-16 19:00:00	SPY	ETF	93.85	93.85	93.77	93.79	23814.0
2009-07-16 05:00:00	QQQ	ETF	36.81	36.81	36.81	36.81	200.0
2009-07-16 06:00:00	QQQ	ETF	36.78	36.87	36.75	36.87	54850.0
2009-07-16 07:00:00	QQQ	ETF	36.85	36.86	36.78	36.79	299353.0
2009-07-16 08:00:00	QQQ	ETF	36.79	36.92	36.7	36.72	3058151.0
2009-07-16 09:00:00	QQQ	ETF	36.72	37.13	36.7	37.1	23239316.0
2009-07-16 10:00:00	QQQ	ETF	37.09	37.1	36.87	36.98	19443043.0
2009-07-16 11:00:00	QQQ	ETF	36.97	37.09	36.92	37.06	7349413.0
2009-07-16 12:00:00	QQQ	ETF	37.07	37.09	37.02	37.0201	4439642.0
2009-07-16 13:00:00	QQQ	ETF	37.02	37.2	36.99	37.2	7610217.0
2009-07-16 14:00:00	QQQ	ETF	37.2	37.34	37.1505	37.29	14890962.0
2009-07-16 15:00:00	QQQ	ETF	37.29	37.44	37.24	37.35	23743903.0
2009-07-16 16:00:00	QQQ	ETF	37.36	37.45	36.92	37.19	9606405.0
2009-07-16 17:00:00	QQQ	ETF	37.19	37.2	37.12	37.14	746676.0
2009-07-16 18:00:00	QQQ	ETF	37.12	37.36	37.12	37.15	101954.0
2009-07-16 19:00:00	QQQ	ETF	37.15	37.15	37.12	37.12	109130.0
2009-07-16 07:00:00	IWM	ETF	51.44	51.44	51.27	51.27	44806.0
2009-07-16 08:00:00	IWM	ETF	51.27	51.72	51.26	51.33	410087.0
2009-07-16 09:00:00	IWM	ETF	51.32	51.68	51.14	51.62	4173003.0
2009-07-16 10:00:00	IWM	ETF	51.62	51.63	51.29	51.46	4519963.0
2009-07-16 11:00:00	IWM	ETF	51.46	51.55	51.26	51.45	2226490.0
2009-07-16 12:00:00	IWM	ETF	51.46	51.61	51.42	51.545	3247087.0
2009-07-16 13:00:00	IWM	ETF	51.53	51.79	51.48	51.79	3807143.0
2009-07-16 14:00:00	IWM	ETF	51.79	52.15	51.73	52.07	6920576.0
2009-07-16 15:00:00	IWM	ETF	52.08	52.37	51.98	52.14	10010756.0
2009-07-16 16:00:00	IWM	ETF	52.15	52.19	51.5628	52.02	2282683.0
2009-07-16 17:00:00	IWM	ETF	52.03	52.1	51.92	51.95	61395.0
2009-07-16 18:00:00	IWM	ETF	51.95	51.97	51.89	51.89	2566.0
2009-07-16 19:00:00	IWM	ETF	51.94	51.94	51.94	51.94	1200.0
2009-07-16 06:00:00	DIA	ETF	85.93	86.17	85.93	86.16	2406.0
2009-07-16 07:00:00	DIA	ETF	86.16	86.21	85.93	85.95	13829.0
2009-07-16 08:00:00	DIA	ETF	85.94	86.66	85.93	86.14	167318.0
2009-07-16 09:00:00	DIA	ETF	86.16	86.68	86.029	86.55	1356248.0
2009-07-16 10:00:00	DIA	ETF	86.54	86.54	86.09	86.35	2087349.0
2009-07-16 11:00:00	DIA	ETF	86.45	86.45	86.12	86.38	946400.0

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

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