PREVIEW / etf_1hour / 2011-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-14.parquet
  size:    186 KB
  rows:    5,753

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-12-14 04:00:00	SPY	ETF	123.42	123.71	123.39	123.71	9908.0
2011-12-14 05:00:00	SPY	ETF	123.68	123.73	123.39	123.5	23550.0
2011-12-14 06:00:00	SPY	ETF	123.45	123.49	122.84	122.97	361748.0
2011-12-14 07:00:00	SPY	ETF	122.92	123.18	122.75	123.1	858366.0
2011-12-14 08:00:00	SPY	ETF	123.08	123.44	122.81	122.84	2235565.0
2011-12-14 09:00:00	SPY	ETF	122.84	123.03	122.09	122.43	26869776.0
2011-12-14 10:00:00	SPY	ETF	122.44	122.45	121.77	121.8001	34858605.0
2011-12-14 11:00:00	SPY	ETF	121.8	122.0	121.53	121.661	22031328.0
2011-12-14 12:00:00	SPY	ETF	121.6601	122.28	121.6	122.15	23284944.0
2011-12-14 13:00:00	SPY	ETF	122.15	122.58	122.0	122.08	27130743.0
2011-12-14 14:00:00	SPY	ETF	122.09	122.17	121.52	121.69	26343601.0
2011-12-14 15:00:00	SPY	ETF	121.69	122.1	121.47	121.74	49090059.0
2011-12-14 16:00:00	SPY	ETF	121.74	123.1414	121.6	121.83	14756251.0
2011-12-14 17:00:00	SPY	ETF	121.85	121.89	121.65	121.72	4104878.0
2011-12-14 18:00:00	SPY	ETF	121.73	121.82	121.63	121.81	413408.0
2011-12-14 19:00:00	SPY	ETF	121.8	121.98	121.74	121.78	480451.0
2011-12-14 05:00:00	QQQ	ETF	55.82	55.82	55.75	55.76	2700.0
2011-12-14 06:00:00	QQQ	ETF	55.76	55.76	55.63	55.63	12692.0
2011-12-14 07:00:00	QQQ	ETF	55.62	55.7	55.55	55.7	55835.0
2011-12-14 08:00:00	QQQ	ETF	55.68	55.78	55.58	55.61	409850.0
2011-12-14 09:00:00	QQQ	ETF	55.61	55.61	55.13	55.38	6684707.0
2011-12-14 10:00:00	QQQ	ETF	55.4	55.4	54.91	54.91	11198511.0
2011-12-14 11:00:00	QQQ	ETF	54.91	54.99	54.58	54.71	8620856.0
2011-12-14 12:00:00	QQQ	ETF	54.71	54.97	54.67	54.92	5285477.0
2011-12-14 13:00:00	QQQ	ETF	54.93	55.16	54.866	54.95	7660908.0
2011-12-14 14:00:00	QQQ	ETF	54.97	55.04	54.73	54.8	5528429.0
2011-12-14 15:00:00	QQQ	ETF	54.795	55.06	54.72	54.9	11900087.0
2011-12-14 16:00:00	QQQ	ETF	54.9	54.95	54.84	54.86	1312146.0
2011-12-14 17:00:00	QQQ	ETF	54.88	54.95	54.83	54.9	1331644.0
2011-12-14 18:00:00	QQQ	ETF	54.88	54.88	54.77	54.86	74218.0
2011-12-14 19:00:00	QQQ	ETF	54.9	54.94	54.84	54.88	31930.0
2011-12-14 04:00:00	IWM	ETF	72.24	72.24	72.24	72.24	500.0
2011-12-14 06:00:00	IWM	ETF	72.13	72.13	71.89	71.89	10300.0
2011-12-14 07:00:00	IWM	ETF	71.75	71.89	71.65	71.86	137407.0
2011-12-14 08:00:00	IWM	ETF	71.81	71.95	71.6	71.66	845252.0
2011-12-14 09:00:00	IWM	ETF	71.6	71.76	71.04	71.33	8641508.0
2011-12-14 10:00:00	IWM	ETF	71.33	71.33	70.76	70.78	6972542.0
2011-12-14 11:00:00	IWM	ETF	70.78	70.96	70.58	70.68	5734798.0
2011-12-14 12:00:00	IWM	ETF	70.68	71.2	70.62	71.16	3999755.0
2011-12-14 13:00:00	IWM	ETF	71.16	71.6	70.95	71.02	6097030.0
2011-12-14 14:00:00	IWM	ETF	71.02	71.23	70.72	70.87	6008148.0
2011-12-14 15:00:00	IWM	ETF	70.87	71.1	70.68	70.98	8802680.0
2011-12-14 16:00:00	IWM	ETF	70.98	71.8947	70.9	70.91	12144040.0
2011-12-14 17:00:00	IWM	ETF	70.94	70.95	70.91	70.93	5800.0
2011-12-14 18:00:00	IWM	ETF	70.95	70.95	70.94	70.95	4200.0
2011-12-14 19:00:00	IWM	ETF	70.99	71.07	70.97	70.99	27300.0
2011-12-14 07:00:00	DIA	ETF	119.1	119.1	119.1	119.1	265.0
2011-12-14 08:00:00	DIA	ETF	119.5	119.66	119.31	119.39	17410.0
2011-12-14 09:00:00	DIA	ETF	119.33	119.49	118.75	119.1	843793.0
2011-12-14 10:00:00	DIA	ETF	119.09	119.09	118.4	118.412	1882994.0

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

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