PREVIEW / etf_1hour / 2011-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-19.parquet
  size:    179 KB
  rows:    5,498

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-19 04:00:00	SPY	ETF	122.02	122.41	121.92	122.41	36410.0
2011-10-19 05:00:00	SPY	ETF	122.62	123.11	122.62	123.11	41800.0
2011-10-19 06:00:00	SPY	ETF	123.1	123.28	122.8	123.2	145285.0
2011-10-19 07:00:00	SPY	ETF	123.15	123.19	122.46	122.5	454021.0
2011-10-19 08:00:00	SPY	ETF	122.47	122.91	122.16	122.84	2287767.0
2011-10-19 09:00:00	SPY	ETF	122.83	122.83	122.11	122.46	21929499.0
2011-10-19 10:00:00	SPY	ETF	122.46	123.08	122.08	122.82	35482151.0
2011-10-19 11:00:00	SPY	ETF	122.814	123.02	122.44	122.46	20573101.0
2011-10-19 12:00:00	SPY	ETF	122.45	122.83	122.31	122.62	16062669.0
2011-10-19 13:00:00	SPY	ETF	122.61	122.84	122.07	122.29	20162852.0
2011-10-19 14:00:00	SPY	ETF	122.29	122.4	121.1	121.19	48645864.0
2011-10-19 15:00:00	SPY	ETF	121.18	121.43	120.71	121.12	51732923.0
2011-10-19 16:00:00	SPY	ETF	121.11	122.1793	120.75	121.31	7175269.0
2011-10-19 17:00:00	SPY	ETF	121.32	121.43	121.099	121.43	1080995.0
2011-10-19 18:00:00	SPY	ETF	121.45	121.52	121.14	121.39	150596.0
2011-10-19 19:00:00	SPY	ETF	121.34	121.57	121.34	121.48	44639.0
2011-10-19 06:00:00	QQQ	ETF	57.82	57.94	57.81	57.94	20700.0
2011-10-19 07:00:00	QQQ	ETF	57.84	57.89	57.6	57.61	190900.0
2011-10-19 08:00:00	QQQ	ETF	57.62	58.0125	57.56	57.8	888089.0
2011-10-19 09:00:00	QQQ	ETF	57.8	57.82	57.51	57.58	7654810.0
2011-10-19 10:00:00	QQQ	ETF	57.57	57.85	57.35	57.76	12265897.0
2011-10-19 11:00:00	QQQ	ETF	57.7693	57.835	57.55	57.56	7538382.0
2011-10-19 12:00:00	QQQ	ETF	57.56	57.79	57.54	57.68	3697354.0
2011-10-19 13:00:00	QQQ	ETF	57.6822	57.75	57.3402	57.45	5148219.0
2011-10-19 14:00:00	QQQ	ETF	57.4401	57.47	56.81	56.9297	10064984.0
2011-10-19 15:00:00	QQQ	ETF	56.92	56.97	56.68	56.87	11600664.0
2011-10-19 16:00:00	QQQ	ETF	56.86	57.5773	56.815	56.99	2233965.0
2011-10-19 17:00:00	QQQ	ETF	56.99	57.04	56.9	56.97	544461.0
2011-10-19 18:00:00	QQQ	ETF	57.0	57.08	57.0	57.02	58197.0
2011-10-19 19:00:00	QQQ	ETF	57.0	57.08	57.0	57.08	19693.0
2011-10-19 05:00:00	IWM	ETF	70.69	70.96	70.69	70.96	500.0
2011-10-19 06:00:00	IWM	ETF	70.99	71.11	70.99	71.1	25500.0
2011-10-19 07:00:00	IWM	ETF	71.0	71.04	70.5	70.58	85500.0
2011-10-19 08:00:00	IWM	ETF	70.56	71.59	69.98	70.93	435174.0
2011-10-19 09:00:00	IWM	ETF	70.93	70.98	70.29	70.56	7561019.0
2011-10-19 10:00:00	IWM	ETF	70.56	71.15	70.28	70.92	8803162.0
2011-10-19 11:00:00	IWM	ETF	70.92	70.94	70.47	70.54	7420537.0
2011-10-19 12:00:00	IWM	ETF	70.54	70.83	70.34	70.67	4443931.0
2011-10-19 13:00:00	IWM	ETF	70.66	70.88	70.17	70.35	6639713.0
2011-10-19 14:00:00	IWM	ETF	70.36	70.45	69.22	69.57	10658091.0
2011-10-19 15:00:00	IWM	ETF	69.56	69.75	69.07	69.45	13499929.0
2011-10-19 16:00:00	IWM	ETF	69.45	69.7	69.15	69.68	1635650.0
2011-10-19 17:00:00	IWM	ETF	69.69	69.79	69.64	69.7	28198.0
2011-10-19 18:00:00	IWM	ETF	69.76	69.76	69.75	69.75	1045.0
2011-10-19 19:00:00	IWM	ETF	69.75	69.77	69.69	69.77	3881.0
2011-10-19 05:00:00	DIA	ETF	116.06	116.06	116.06	116.06	100.0
2011-10-19 06:00:00	DIA	ETF	116.02	116.02	116.02	116.02	500.0
2011-10-19 07:00:00	DIA	ETF	116.14	116.14	115.64	115.64	1850.0
2011-10-19 08:00:00	DIA	ETF	115.64	115.92	115.41	115.86	25690.0
2011-10-19 09:00:00	DIA	ETF	115.83	115.87	115.34	115.63	845046.0

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

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