PREVIEW / etf_1hour / 2011-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-31.parquet
  size:    180 KB
  rows:    5,535

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-31 04:00:00	SPY	ETF	127.32	127.5	127.31	127.5	3500.0
2011-01-31 05:00:00	SPY	ETF	127.54	127.85	127.54	127.85	15688.0
2011-01-31 06:00:00	SPY	ETF	127.79	127.9	127.72	127.74	110750.0
2011-01-31 07:00:00	SPY	ETF	127.71	128.12	127.68	128.03	967160.0
2011-01-31 08:00:00	SPY	ETF	128.03	128.21	127.89	128.17	1648412.0
2011-01-31 09:00:00	SPY	ETF	128.16	128.23	127.76	127.85	24779480.0
2011-01-31 10:00:00	SPY	ETF	127.84	128.31	127.75	128.2401	20121015.0
2011-01-31 11:00:00	SPY	ETF	128.25	128.41	128.21	128.3202	13292620.0
2011-01-31 12:00:00	SPY	ETF	128.32	128.78	128.32	128.585	17957673.0
2011-01-31 13:00:00	SPY	ETF	128.585	128.72	128.44	128.54	10240171.0
2011-01-31 14:00:00	SPY	ETF	128.5401	128.65	127.9195	128.42	19034012.0
2011-01-31 15:00:00	SPY	ETF	128.41	128.68	128.385	128.67	26929957.0
2011-01-31 16:00:00	SPY	ETF	128.68	128.76	127.8579	128.66	11961065.0
2011-01-31 17:00:00	SPY	ETF	128.66	128.7	128.58	128.61	221572.0
2011-01-31 18:00:00	SPY	ETF	128.62	128.68	128.56	128.68	115930.0
2011-01-31 19:00:00	SPY	ETF	128.68	128.85	128.68	128.83	37450.0
2011-01-31 04:00:00	QQQ	ETF	55.6	55.69	55.58	55.69	3800.0
2011-01-31 05:00:00	QQQ	ETF	55.82	55.83	55.82	55.83	490.0
2011-01-31 06:00:00	QQQ	ETF	55.86	55.86	55.83	55.83	5500.0
2011-01-31 07:00:00	QQQ	ETF	55.81	55.92	55.77	55.87	48702.0
2011-01-31 08:00:00	QQQ	ETF	55.88	55.92	55.81	55.9	1134141.0
2011-01-31 09:00:00	QQQ	ETF	55.9	55.94	55.39	55.465	14349578.0
2011-01-31 10:00:00	QQQ	ETF	55.46	55.77	55.43	55.74	11511071.0
2011-01-31 11:00:00	QQQ	ETF	55.74	55.89	55.71	55.85	6582341.0
2011-01-31 12:00:00	QQQ	ETF	55.85	56.16	55.84	55.98	8565075.0
2011-01-31 13:00:00	QQQ	ETF	55.98	56.06	55.9	55.999	4286559.0
2011-01-31 14:00:00	QQQ	ETF	56.0	56.04	55.73	55.84	6710742.0
2011-01-31 15:00:00	QQQ	ETF	55.84	56.01	55.81	56.0	8394517.0
2011-01-31 16:00:00	QQQ	ETF	56.0	56.14	55.731	56.04	5663230.0
2011-01-31 17:00:00	QQQ	ETF	56.05	56.07	55.731	56.03	1035520.0
2011-01-31 18:00:00	QQQ	ETF	56.05	56.11	56.04	56.09	17871.0
2011-01-31 19:00:00	QQQ	ETF	56.12	56.21	56.12	56.2	98588.0
2011-01-31 04:00:00	IWM	ETF	77.28	77.34	77.24	77.24	1700.0
2011-01-31 05:00:00	IWM	ETF	77.39	77.6	77.39	77.6	4000.0
2011-01-31 06:00:00	IWM	ETF	77.64	77.69	77.64	77.69	2000.0
2011-01-31 07:00:00	IWM	ETF	77.57	77.83	77.57	77.78	33441.0
2011-01-31 08:00:00	IWM	ETF	77.69	77.89	77.69	77.88	212792.0
2011-01-31 09:00:00	IWM	ETF	77.87	77.95	77.2701	77.33	7591338.0
2011-01-31 10:00:00	IWM	ETF	77.33	77.87	77.25	77.78	6436778.0
2011-01-31 11:00:00	IWM	ETF	77.78	78.06	77.75	77.9712	3480664.0
2011-01-31 12:00:00	IWM	ETF	77.97	78.5	77.97	78.23	4823900.0
2011-01-31 13:00:00	IWM	ETF	78.23	78.44	78.22	78.37	3885188.0
2011-01-31 14:00:00	IWM	ETF	78.37	78.44	77.71	77.9	7213309.0
2011-01-31 15:00:00	IWM	ETF	77.9	78.16	77.86	77.93	8916466.0
2011-01-31 16:00:00	IWM	ETF	77.93	78.14	77.4169	78.07	4177899.0
2011-01-31 17:00:00	IWM	ETF	78.09	78.11	78.0	78.0	7175.0
2011-01-31 18:00:00	IWM	ETF	78.0	78.09	78.0	78.09	1900.0
2011-01-31 19:00:00	IWM	ETF	78.11	78.12	78.11	78.12	4388.0
2011-01-31 06:00:00	DIA	ETF	118.0	118.0	118.0	118.0	500.0
2011-01-31 07:00:00	DIA	ETF	117.92	118.18	117.91	118.18	19275.0

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

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