PREVIEW / etf_1hour / 2011-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-27.parquet
  size:    175 KB
  rows:    5,368

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-01-27 04:00:00	SPY	ETF	129.64	129.67	129.42	129.65	9140.0
2011-01-27 05:00:00	SPY	ETF	129.69	129.85	129.67	129.85	5380.0
2011-01-27 06:00:00	SPY	ETF	129.75	129.75	129.47	129.67	12380.0
2011-01-27 07:00:00	SPY	ETF	129.69	130.01	129.59	129.87	331899.0
2011-01-27 08:00:00	SPY	ETF	129.7	130.0	129.43	129.51	3509086.0
2011-01-27 09:00:00	SPY	ETF	129.5	130.02	129.47	129.97	20553189.0
2011-01-27 10:00:00	SPY	ETF	129.97	130.17	129.77	129.935	18933179.0
2011-01-27 11:00:00	SPY	ETF	129.94	129.96	129.47	129.7	19609325.0
2011-01-27 12:00:00	SPY	ETF	129.71	129.97	129.68	129.95	9741703.0
2011-01-27 13:00:00	SPY	ETF	129.95	130.02	129.86	129.9562	7392155.0
2011-01-27 14:00:00	SPY	ETF	129.96	130.05	129.79	129.99	10649414.0
2011-01-27 15:00:00	SPY	ETF	130.0	130.21	129.88	130.02	24456205.0
2011-01-27 16:00:00	SPY	ETF	130.02	130.06	129.56	129.93	7970988.0
2011-01-27 17:00:00	SPY	ETF	129.93	129.95	129.85	129.89	170891.0
2011-01-27 18:00:00	SPY	ETF	129.88	130.03	129.84	129.85	52785.0
2011-01-27 19:00:00	SPY	ETF	129.86	129.86	129.8	129.84	57917.0
2011-01-27 04:00:00	QQQ	ETF	56.93	56.93	56.93	56.93	300.0
2011-01-27 05:00:00	QQQ	ETF	57.0	57.02	57.0	57.02	200.0
2011-01-27 06:00:00	QQQ	ETF	57.02	57.02	56.99	56.99	282.0
2011-01-27 07:00:00	QQQ	ETF	56.99	57.08	56.97	57.02	34775.0
2011-01-27 08:00:00	QQQ	ETF	57.12	57.12	56.89	56.92	365273.0
2011-01-27 09:00:00	QQQ	ETF	56.92	57.18	56.91	57.15	5812497.0
2011-01-27 10:00:00	QQQ	ETF	57.15	57.22	57.0	57.08	6513449.0
2011-01-27 11:00:00	QQQ	ETF	57.08	57.11	56.92	57.0695	7482717.0
2011-01-27 12:00:00	QQQ	ETF	57.07	57.27	57.05	57.25	6468030.0
2011-01-27 13:00:00	QQQ	ETF	57.26	57.27	57.17	57.24	2103078.0
2011-01-27 14:00:00	QQQ	ETF	57.23	57.27	57.15	57.25	2713446.0
2011-01-27 15:00:00	QQQ	ETF	57.25	57.35	57.15	57.18	14301179.0
2011-01-27 16:00:00	QQQ	ETF	57.18	57.2346	57.0	57.02	4278945.0
2011-01-27 17:00:00	QQQ	ETF	57.03	57.03	57.0	57.0	63495.0
2011-01-27 18:00:00	QQQ	ETF	57.02	57.03	57.0	57.03	8659.0
2011-01-27 19:00:00	QQQ	ETF	57.01	57.02	56.99	57.01	9142.0
2011-01-27 05:00:00	IWM	ETF	79.12	79.12	79.12	79.12	100.0
2011-01-27 07:00:00	IWM	ETF	79.19	79.29	79.19	79.29	3600.0
2011-01-27 08:00:00	IWM	ETF	79.31	79.54	78.98	79.01	403438.0
2011-01-27 09:00:00	IWM	ETF	79.0	79.35	78.95	79.33	5170240.0
2011-01-27 10:00:00	IWM	ETF	79.32	79.42	79.07	79.23	8615238.0
2011-01-27 11:00:00	IWM	ETF	79.24	79.29	78.73	79.18	8101712.0
2011-01-27 12:00:00	IWM	ETF	79.19	79.63	79.16	79.57	6431242.0
2011-01-27 13:00:00	IWM	ETF	79.57	79.67	79.34	79.55	3185648.0
2011-01-27 14:00:00	IWM	ETF	79.55	79.5599	79.31	79.5	3369422.0
2011-01-27 15:00:00	IWM	ETF	79.51	79.66	79.34	79.35	7177453.0
2011-01-27 16:00:00	IWM	ETF	79.35	79.5357	79.15	79.19	1500151.0
2011-01-27 17:00:00	IWM	ETF	79.19	79.22	79.19	79.22	11900.0
2011-01-27 18:00:00	IWM	ETF	79.21	79.26	79.21	79.26	11080.0
2011-01-27 19:00:00	IWM	ETF	79.25	79.25	79.21	79.24	7600.0
2011-01-27 06:00:00	DIA	ETF	119.72	119.72	119.66	119.66	1108.0
2011-01-27 07:00:00	DIA	ETF	119.63	119.85	119.63	119.85	4600.0
2011-01-27 08:00:00	DIA	ETF	119.79	119.86	119.5	119.5	18492.0
2011-01-27 09:00:00	DIA	ETF	119.51	119.79	119.49	119.75	1060723.0

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

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