PREVIEW / etf_1hour / 2013-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-21.parquet
  size:    209 KB
  rows:    6,520

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-08-21 04:00:00	SPY	ETF	165.25	165.35	165.18	165.2	48425.0
2013-08-21 05:00:00	SPY	ETF	165.17	165.17	164.95	165.11	91095.0
2013-08-21 06:00:00	SPY	ETF	165.11	165.16	165.0	165.04	36200.0
2013-08-21 07:00:00	SPY	ETF	165.07	165.35	165.02	165.29	241299.0
2013-08-21 08:00:00	SPY	ETF	165.29	165.41	165.05	165.2	347855.0
2013-08-21 09:00:00	SPY	ETF	165.21	165.42	164.91	165.19	13675960.0
2013-08-21 10:00:00	SPY	ETF	165.18	165.5331	164.95	165.17	14100687.0
2013-08-21 11:00:00	SPY	ETF	165.17	165.22	164.57	164.7701	13092220.0
2013-08-21 12:00:00	SPY	ETF	164.778	165.05	164.71	165.035	6648725.0
2013-08-21 13:00:00	SPY	ETF	165.01	165.2	164.89	165.17	9155684.0
2013-08-21 14:00:00	SPY	ETF	165.17	166.03	164.19	165.7	47071919.0
2013-08-21 15:00:00	SPY	ETF	165.705	165.76	164.49	164.58	32662054.0
2013-08-21 16:00:00	SPY	ETF	164.57	165.5336	164.05	164.1	19653459.0
2013-08-21 17:00:00	SPY	ETF	164.09	165.5336	163.97	164.07	1609910.0
2013-08-21 18:00:00	SPY	ETF	164.07	164.12	163.92	163.95	113605.0
2013-08-21 19:00:00	SPY	ETF	163.94	164.01	163.8	163.84	73701.0
2013-08-21 04:00:00	QQQ	ETF	75.49	75.54	75.46	75.48	17100.0
2013-08-21 05:00:00	QQQ	ETF	75.46	75.46	75.34	75.38	12000.0
2013-08-21 06:00:00	QQQ	ETF	75.4	75.4	75.34	75.36	5900.0
2013-08-21 07:00:00	QQQ	ETF	75.38	75.53	75.36	75.5	13500.0
2013-08-21 08:00:00	QQQ	ETF	75.52	75.55	75.4	75.46	70400.0
2013-08-21 09:00:00	QQQ	ETF	75.46	75.82	75.4099	75.75	3005443.0
2013-08-21 10:00:00	QQQ	ETF	75.74	75.88	75.66	75.78	3652170.0
2013-08-21 11:00:00	QQQ	ETF	75.78	75.8	75.39	75.49	3302093.0
2013-08-21 12:00:00	QQQ	ETF	75.489	75.57	75.45	75.51	1320126.0
2013-08-21 13:00:00	QQQ	ETF	75.518	75.65	75.45	75.6	1420664.0
2013-08-21 14:00:00	QQQ	ETF	75.59	76.09	75.14	75.95	9665118.0
2013-08-21 15:00:00	QQQ	ETF	75.94	75.98	75.37	75.42	6493001.0
2013-08-21 16:00:00	QQQ	ETF	75.42	75.8881	75.18	75.18	1639597.0
2013-08-21 17:00:00	QQQ	ETF	75.16	75.24	75.13	75.23	40999.0
2013-08-21 18:00:00	QQQ	ETF	75.2	75.22	75.13	75.13	17045.0
2013-08-21 19:00:00	QQQ	ETF	75.13	75.17	75.1	75.12	12162.0
2013-08-21 07:00:00	IWM	ETF	101.55	101.93	101.55	101.93	28420.0
2013-08-21 08:00:00	IWM	ETF	101.91	101.97	101.75	101.77	78432.0
2013-08-21 09:00:00	IWM	ETF	101.78	101.985	101.53	101.76	4430052.0
2013-08-21 10:00:00	IWM	ETF	101.75	101.99	101.51	101.705	3169509.0
2013-08-21 11:00:00	IWM	ETF	101.685	101.72	101.08	101.36	3981732.0
2013-08-21 12:00:00	IWM	ETF	101.37	101.625	101.32	101.605	1644970.0
2013-08-21 13:00:00	IWM	ETF	101.59	101.93	101.53	101.92	2968473.0
2013-08-21 14:00:00	IWM	ETF	101.92	102.5	101.01	102.36	12116279.0
2013-08-21 15:00:00	IWM	ETF	102.37	102.39	101.42	101.46	6634144.0
2013-08-21 16:00:00	IWM	ETF	101.46	101.8388	101.18	101.2	1355517.0
2013-08-21 17:00:00	IWM	ETF	101.18	101.19	101.08	101.08	57362.0
2013-08-21 18:00:00	IWM	ETF	101.08	101.19	101.05	101.13	5650.0
2013-08-21 19:00:00	IWM	ETF	101.16	101.16	101.01	101.1	5300.0
2013-08-21 04:00:00	DIA	ETF	149.69	149.69	149.65	149.65	1677.0
2013-08-21 06:00:00	DIA	ETF	149.44	149.44	149.44	149.44	1000.0
2013-08-21 08:00:00	DIA	ETF	149.6	149.6	149.45	149.48	1910.0
2013-08-21 09:00:00	DIA	ETF	149.43	149.63	149.25	149.38	827179.0
2013-08-21 10:00:00	DIA	ETF	149.38	149.55	149.13	149.32	1337346.0

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

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