PREVIEW / etf_1hour / 2011-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-03.parquet
  size:    195 KB
  rows:    6,068

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
2011-10-03 04:00:00	SPY	ETF	112.25	112.92	112.25	112.65	16732.0
2011-10-03 05:00:00	SPY	ETF	112.49	112.87	112.47	112.56	58698.0
2011-10-03 06:00:00	SPY	ETF	112.46	113.19	112.46	113.0	101156.0
2011-10-03 07:00:00	SPY	ETF	112.99	113.1	112.7	113.07	1081239.0
2011-10-03 08:00:00	SPY	ETF	112.95	113.27	112.01	112.41	2699375.0
2011-10-03 09:00:00	SPY	ETF	112.41	113.17	112.08	112.19	28028750.0
2011-10-03 10:00:00	SPY	ETF	112.2	113.95	112.08	112.415	65013080.0
2011-10-03 11:00:00	SPY	ETF	112.43	113.2	112.1	113.07	38328191.0
2011-10-03 12:00:00	SPY	ETF	113.06	113.17	111.66	111.72	29139699.0
2011-10-03 13:00:00	SPY	ETF	111.72	111.73	110.4	110.91	47271257.0
2011-10-03 14:00:00	SPY	ETF	110.91	111.33	110.16	110.71	46184024.0
2011-10-03 15:00:00	SPY	ETF	110.71	111.27	109.81	109.92	79462869.0
2011-10-03 16:00:00	SPY	ETF	109.88	113.1304	109.16	109.25	24597080.0
2011-10-03 17:00:00	SPY	ETF	109.26	109.28	109.02	109.27	762359.0
2011-10-03 18:00:00	SPY	ETF	109.25	109.93	109.15	109.42	434771.0
2011-10-03 19:00:00	SPY	ETF	109.41	109.43	109.1	109.32	360709.0
2011-10-03 04:00:00	QQQ	ETF	52.05	52.08	52.05	52.08	2052.0
2011-10-03 05:00:00	QQQ	ETF	52.22	52.22	52.1	52.15	11869.0
2011-10-03 06:00:00	QQQ	ETF	52.34	52.35	52.27	52.27	25500.0
2011-10-03 07:00:00	QQQ	ETF	52.24	52.29	52.12	52.25	150158.0
2011-10-03 08:00:00	QQQ	ETF	52.25	52.37	51.98	52.01	486017.0
2011-10-03 09:00:00	QQQ	ETF	52.01	52.49	51.8	51.901	9881148.0
2011-10-03 10:00:00	QQQ	ETF	51.87	52.85	51.82	52.13	17622657.0
2011-10-03 11:00:00	QQQ	ETF	52.13	52.54	52.02	52.43	8682594.0
2011-10-03 12:00:00	QQQ	ETF	52.44	52.48	51.79	51.85	8735732.0
2011-10-03 13:00:00	QQQ	ETF	51.85	51.85	51.32	51.58	10695909.0
2011-10-03 14:00:00	QQQ	ETF	51.57	51.72	51.17	51.36	11652057.0
2011-10-03 15:00:00	QQQ	ETF	51.3601	51.73	51.11	51.12	19624024.0
2011-10-03 16:00:00	QQQ	ETF	51.12	51.14	50.77	50.84	2222401.0
2011-10-03 17:00:00	QQQ	ETF	50.85	50.85	50.7	50.75	601364.0
2011-10-03 18:00:00	QQQ	ETF	51.14	51.14	50.75	50.84	214944.0
2011-10-03 19:00:00	QQQ	ETF	50.84	50.87	50.7	50.82	30709.0
2011-10-03 04:00:00	IWM	ETF	63.79	63.97	63.61	63.92	7270.0
2011-10-03 05:00:00	IWM	ETF	64.0	64.0	64.0	64.0	100.0
2011-10-03 06:00:00	IWM	ETF	64.22	64.25	64.05	64.05	24000.0
2011-10-03 07:00:00	IWM	ETF	64.13	64.16	63.88	64.16	153898.0
2011-10-03 08:00:00	IWM	ETF	64.18	64.32	63.77	63.78	439773.0
2011-10-03 09:00:00	IWM	ETF	63.76	64.48	63.49	63.68	10441283.0
2011-10-03 10:00:00	IWM	ETF	63.66	64.96	63.62	64.05	18031595.0
2011-10-03 11:00:00	IWM	ETF	64.05	64.43	63.79	64.16	6700518.0
2011-10-03 12:00:00	IWM	ETF	64.17	64.2	62.71	62.73	9250331.0
2011-10-03 13:00:00	IWM	ETF	62.73	62.73	61.62	61.98	15848982.0
2011-10-03 14:00:00	IWM	ETF	61.99	62.33	61.39	61.68	16691703.0
2011-10-03 15:00:00	IWM	ETF	61.68	61.94	60.85	60.93	21942746.0
2011-10-03 16:00:00	IWM	ETF	60.93	64.5	60.46	60.77	11766106.0
2011-10-03 17:00:00	IWM	ETF	60.76	60.76	60.57	60.65	48070.0
2011-10-03 18:00:00	IWM	ETF	60.64	60.77	60.63	60.75	5400.0
2011-10-03 19:00:00	IWM	ETF	60.82	60.82	60.7	60.71	21570.0
2011-10-03 06:00:00	DIA	ETF	108.82	108.82	108.82	108.82	200.0
2011-10-03 07:00:00	DIA	ETF	108.55	108.69	108.52	108.57	4000.0

> showing 50 of 6,068 rows — these rows as CSV

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