PREVIEW / etf_1hour / 2013-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-01.parquet
  size:    209 KB
  rows:    6,541

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
2013-07-01 04:00:00	SPY	ETF	161.2	161.26	160.68	160.7	20713.0
2013-07-01 05:00:00	SPY	ETF	160.74	161.35	160.7	161.31	109149.0
2013-07-01 06:00:00	SPY	ETF	161.31	161.38	160.98	161.06	66545.0
2013-07-01 07:00:00	SPY	ETF	161.03	161.22	160.96	161.1	223639.0
2013-07-01 08:00:00	SPY	ETF	161.06	161.24	160.05	161.05	847480.0
2013-07-01 09:00:00	SPY	ETF	161.05	161.97	161.02	161.85	19364997.0
2013-07-01 10:00:00	SPY	ETF	161.88	162.44	161.8	162.0999	21612261.0
2013-07-01 11:00:00	SPY	ETF	162.1	162.41	162.08	162.37	11611979.0
2013-07-01 12:00:00	SPY	ETF	162.38	162.48	162.07	162.17	10172377.0
2013-07-01 13:00:00	SPY	ETF	162.17	162.27	161.7	161.705	11391255.0
2013-07-01 14:00:00	SPY	ETF	161.7	161.92	161.51	161.83	12500059.0
2013-07-01 15:00:00	SPY	ETF	161.83	161.985	161.08	161.35	29343202.0
2013-07-01 16:00:00	SPY	ETF	161.34	161.9497	161.03	161.11	4829603.0
2013-07-01 17:00:00	SPY	ETF	161.11	161.16	161.08	161.1	1113484.0
2013-07-01 18:00:00	SPY	ETF	161.1	161.24	161.1	161.22	82419.0
2013-07-01 19:00:00	SPY	ETF	161.19	161.25	161.15	161.2	214249.0
2013-07-01 04:00:00	QQQ	ETF	71.67	71.67	71.45	71.48	21922.0
2013-07-01 05:00:00	QQQ	ETF	71.51	71.79	71.48	71.77	13400.0
2013-07-01 06:00:00	QQQ	ETF	71.75	71.75	71.6	71.64	6400.0
2013-07-01 07:00:00	QQQ	ETF	71.6	71.69	71.58	71.64	16800.0
2013-07-01 08:00:00	QQQ	ETF	71.64	71.78	71.62	71.65	46893.0
2013-07-01 09:00:00	QQQ	ETF	71.63	72.14	71.63	72.11	5202692.0
2013-07-01 10:00:00	QQQ	ETF	72.12	72.3	72.08	72.09	4667914.0
2013-07-01 11:00:00	QQQ	ETF	72.09	72.21	72.06	72.1917	1969543.0
2013-07-01 12:00:00	QQQ	ETF	72.191	72.22	71.98	72.04	2095511.0
2013-07-01 13:00:00	QQQ	ETF	72.04	72.12	71.87	71.87	2149527.0
2013-07-01 14:00:00	QQQ	ETF	71.87	71.99	71.73	71.96	2572424.0
2013-07-01 15:00:00	QQQ	ETF	71.96	72.01	71.64	71.72	4588984.0
2013-07-01 16:00:00	QQQ	ETF	71.72	72.131	71.6	71.65	1156970.0
2013-07-01 17:00:00	QQQ	ETF	71.64	71.7	71.61	71.66	3765.0
2013-07-01 18:00:00	QQQ	ETF	71.65	71.67	71.65	71.67	8899.0
2013-07-01 19:00:00	QQQ	ETF	71.68	71.7	71.66	71.7	4106.0
2013-07-01 04:00:00	IWM	ETF	97.75	97.75	97.75	97.75	1000.0
2013-07-01 05:00:00	IWM	ETF	97.75	98.02	97.75	98.02	11200.0
2013-07-01 06:00:00	IWM	ETF	98.1	98.1	97.89	97.89	11093.0
2013-07-01 07:00:00	IWM	ETF	97.91	98.0	97.82	97.83	76458.0
2013-07-01 08:00:00	IWM	ETF	97.83	98.17	97.0	97.64	186291.0
2013-07-01 09:00:00	IWM	ETF	97.61	98.4	97.39	98.33	5495153.0
2013-07-01 10:00:00	IWM	ETF	98.31	98.72	98.28	98.562	5789064.0
2013-07-01 11:00:00	IWM	ETF	98.57	98.89	98.54	98.88	2927739.0
2013-07-01 12:00:00	IWM	ETF	98.88	99.03	98.78	98.94	3710805.0
2013-07-01 13:00:00	IWM	ETF	98.945	99.1	98.65	98.665	2837901.0
2013-07-01 14:00:00	IWM	ETF	98.66	98.89	98.58	98.821	3884498.0
2013-07-01 15:00:00	IWM	ETF	98.83	98.95	98.33	98.57	8225433.0
2013-07-01 16:00:00	IWM	ETF	98.57	98.6627	98.42	98.5	1974614.0
2013-07-01 17:00:00	IWM	ETF	98.5	98.54	98.48	98.49	47566.0
2013-07-01 18:00:00	IWM	ETF	98.51	98.53	98.51	98.51	600.0
2013-07-01 19:00:00	IWM	ETF	98.56	98.56	98.54	98.54	5600.0
2013-07-01 06:00:00	DIA	ETF	149.5	149.5	149.38	149.38	284.0
2013-07-01 07:00:00	DIA	ETF	149.39	149.44	149.39	149.44	1134.0

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

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