PREVIEW / etf_1hour / 2010-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-27.parquet
  size:    165 KB
  rows:    5,066

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
2010-09-27 04:00:00	SPY	ETF	114.95	114.95	114.75	114.75	1600.0
2010-09-27 05:00:00	SPY	ETF	114.79	114.81	114.79	114.79	4600.0
2010-09-27 06:00:00	SPY	ETF	114.92	114.92	114.73	114.84	1600.0
2010-09-27 07:00:00	SPY	ETF	114.86	114.94	114.8	114.84	180102.0
2010-09-27 08:00:00	SPY	ETF	114.86	114.96	114.77	114.94	1521525.0
2010-09-27 09:00:00	SPY	ETF	114.95	115.04	114.41	114.5	19933827.0
2010-09-27 10:00:00	SPY	ETF	114.5	114.81	114.38	114.725	17668068.0
2010-09-27 11:00:00	SPY	ETF	114.72	114.725	114.31	114.42	17230717.0
2010-09-27 12:00:00	SPY	ETF	114.4262	114.54	114.37	114.4399	7277883.0
2010-09-27 13:00:00	SPY	ETF	114.44	114.84	114.32	114.76	13551926.0
2010-09-27 14:00:00	SPY	ETF	114.76	114.99	114.42	114.81	13618491.0
2010-09-27 15:00:00	SPY	ETF	114.81	114.81	114.16	114.29	27340779.0
2010-09-27 16:00:00	SPY	ETF	114.29	114.735	114.17	114.29	5887925.0
2010-09-27 17:00:00	SPY	ETF	114.31	114.36	114.24	114.24	157975.0
2010-09-27 18:00:00	SPY	ETF	114.27	114.33	114.21	114.23	205250.0
2010-09-27 19:00:00	SPY	ETF	114.23	114.24	114.21	114.23	38554.0
2010-09-27 04:00:00	QQQ	ETF	49.79	49.79	49.66	49.66	400.0
2010-09-27 06:00:00	QQQ	ETF	49.64	49.64	49.64	49.64	200.0
2010-09-27 07:00:00	QQQ	ETF	49.67	49.68	49.63	49.66	93286.0
2010-09-27 08:00:00	QQQ	ETF	49.66	49.7	49.63	49.7	200113.0
2010-09-27 09:00:00	QQQ	ETF	49.7	49.75	49.47	49.51	6325514.0
2010-09-27 10:00:00	QQQ	ETF	49.5125	49.65	49.46	49.5677	7569300.0
2010-09-27 11:00:00	QQQ	ETF	49.57	49.57	49.4	49.47	7701545.0
2010-09-27 12:00:00	QQQ	ETF	49.48	49.53	49.44	49.47	3233098.0
2010-09-27 13:00:00	QQQ	ETF	49.475	49.68	49.44	49.6501	4786717.0
2010-09-27 14:00:00	QQQ	ETF	49.65	49.75	49.62	49.64	4118434.0
2010-09-27 15:00:00	QQQ	ETF	49.64	49.65	49.35	49.39	6021078.0
2010-09-27 16:00:00	QQQ	ETF	49.39	49.655	49.3	49.35	1362938.0
2010-09-27 17:00:00	QQQ	ETF	49.36	49.39	49.31	49.36	49759.0
2010-09-27 18:00:00	QQQ	ETF	49.37	49.38	49.35	49.36	30182.0
2010-09-27 19:00:00	QQQ	ETF	49.35	49.36	49.35	49.35	6472.0
2010-09-27 05:00:00	IWM	ETF	67.05	67.05	67.05	67.05	500.0
2010-09-27 06:00:00	IWM	ETF	67.0	67.0	67.0	67.0	100.0
2010-09-27 07:00:00	IWM	ETF	67.05	67.07	66.99	67.01	18100.0
2010-09-27 08:00:00	IWM	ETF	67.07	67.16	66.99	67.13	190720.0
2010-09-27 09:00:00	IWM	ETF	67.18	67.22	66.65	66.8	4620198.0
2010-09-27 10:00:00	IWM	ETF	66.8	67.05	66.75	66.96	6487201.0
2010-09-27 11:00:00	IWM	ETF	66.96	66.96	66.561	66.72	5683185.0
2010-09-27 12:00:00	IWM	ETF	66.72	66.83	66.51	66.62	3352170.0
2010-09-27 13:00:00	IWM	ETF	66.63	67.09	66.54	67.04	4369891.0
2010-09-27 14:00:00	IWM	ETF	67.03	67.16	66.96	66.99	5002194.0
2010-09-27 15:00:00	IWM	ETF	66.98	67.07	66.68	66.82	8212880.0
2010-09-27 16:00:00	IWM	ETF	66.81	67.0569	66.73	66.8	4044268.0
2010-09-27 17:00:00	IWM	ETF	66.8	66.86	66.79	66.85	38888.0
2010-09-27 18:00:00	IWM	ETF	66.81	66.81	66.71	66.71	10100.0
2010-09-27 19:00:00	IWM	ETF	66.71	66.71	66.71	66.71	2000.0
2010-09-27 06:00:00	DIA	ETF	108.68	108.68	108.68	108.68	100.0
2010-09-27 07:00:00	DIA	ETF	108.68	108.75	108.68	108.75	200.0
2010-09-27 08:00:00	DIA	ETF	108.68	108.72	108.61	108.64	6062.0
2010-09-27 09:00:00	DIA	ETF	108.74	108.74	108.2741	108.369	696450.0

> showing 50 of 5,066 rows — these rows as CSV

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