PREVIEW / etf_1hour / 2015-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-29.parquet
  size:    243 KB
  rows:    7,654

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
2015-01-29 04:00:00	SPY	ETF	199.88	200.12	199.86	199.96	12163.0
2015-01-29 05:00:00	SPY	ETF	199.96	200.51	199.94	200.26	60494.0
2015-01-29 06:00:00	SPY	ETF	200.22	200.75	200.04	200.62	80084.0
2015-01-29 07:00:00	SPY	ETF	200.64	200.69	200.09	200.15	472369.0
2015-01-29 08:00:00	SPY	ETF	200.17	200.66	199.67	200.22	1532362.0
2015-01-29 09:00:00	SPY	ETF	200.24	200.58	199.01	199.87	24601007.0
2015-01-29 10:00:00	SPY	ETF	199.86	200.2	198.68	199.235	28493219.0
2015-01-29 11:00:00	SPY	ETF	199.23	200.21	198.83	199.85	22134587.0
2015-01-29 12:00:00	SPY	ETF	199.85	200.38	199.52	199.94	11607110.0
2015-01-29 13:00:00	SPY	ETF	199.95	201.22	199.67	200.84	14124219.0
2015-01-29 14:00:00	SPY	ETF	200.85	201.44	200.63	201.14	12182765.0
2015-01-29 15:00:00	SPY	ETF	201.13	202.3	201.03	201.98	26019020.0
2015-01-29 16:00:00	SPY	ETF	202.0	202.42	199.7667	202.33	12391612.0
2015-01-29 17:00:00	SPY	ETF	202.35	202.45	202.31	202.39	16162418.0
2015-01-29 18:00:00	SPY	ETF	202.38	202.45	202.19	202.24	108427.0
2015-01-29 19:00:00	SPY	ETF	202.2	202.22	201.95	202.0	160110.0
2015-01-29 06:00:00	QQQ	ETF	101.04	101.11	100.99	101.02	40750.0
2015-01-29 07:00:00	QQQ	ETF	101.09	101.14	100.78	100.8	173565.0
2015-01-29 08:00:00	QQQ	ETF	100.8	100.92	100.55	100.81	420556.0
2015-01-29 09:00:00	QQQ	ETF	100.83	100.99	99.96	100.48	7529702.0
2015-01-29 10:00:00	QQQ	ETF	100.485	100.73	100.08	100.375	7103203.0
2015-01-29 11:00:00	QQQ	ETF	100.37	100.77	100.14	100.56	4697136.0
2015-01-29 12:00:00	QQQ	ETF	100.565	100.84	100.36	100.5901	2971294.0
2015-01-29 13:00:00	QQQ	ETF	100.6	101.29	100.44	101.129	3898859.0
2015-01-29 14:00:00	QQQ	ETF	101.13	101.53	101.04	101.43	2927473.0
2015-01-29 15:00:00	QQQ	ETF	101.43	102.0779	101.36	101.87	6225071.0
2015-01-29 16:00:00	QQQ	ETF	101.88	102.43	100.3996	102.41	2869059.0
2015-01-29 17:00:00	QQQ	ETF	102.4	102.56	102.39	102.51	117170.0
2015-01-29 18:00:00	QQQ	ETF	102.52	102.66	101.89	102.51	58729.0
2015-01-29 19:00:00	QQQ	ETF	102.51	102.6	102.41	102.42	45561.0
2015-01-29 04:00:00	IWM	ETF	116.94	116.94	116.94	116.94	100.0
2015-01-29 06:00:00	IWM	ETF	116.85	116.85	116.79	116.79	400.0
2015-01-29 07:00:00	IWM	ETF	116.9	116.9	116.65	116.74	21200.0
2015-01-29 08:00:00	IWM	ETF	116.68	116.84	116.36	116.83	273442.0
2015-01-29 09:00:00	IWM	ETF	116.86	117.26	116.09	116.73	4025207.0
2015-01-29 10:00:00	IWM	ETF	116.72	116.82	116.17	116.44	4648009.0
2015-01-29 11:00:00	IWM	ETF	116.45	116.95	116.14	116.57	3897503.0
2015-01-29 12:00:00	IWM	ETF	116.57	116.76	116.2	116.44	3042246.0
2015-01-29 13:00:00	IWM	ETF	116.44	117.83	116.265	117.46	4502205.0
2015-01-29 14:00:00	IWM	ETF	117.47	117.76	117.35	117.599	2942001.0
2015-01-29 15:00:00	IWM	ETF	117.59	118.28	117.55	118.28	7319439.0
2015-01-29 16:00:00	IWM	ETF	118.29	118.55	118.24	118.52	1337515.0
2015-01-29 17:00:00	IWM	ETF	118.51	118.66	118.51	118.64	125242.0
2015-01-29 18:00:00	IWM	ETF	118.64	118.85	118.64	118.64	6849.0
2015-01-29 19:00:00	IWM	ETF	118.64	118.87	118.57	118.87	1200.0
2015-01-29 07:00:00	DIA	ETF	172.35	172.35	172.0	172.15	2300.0
2015-01-29 08:00:00	DIA	ETF	172.05	172.2	171.73	172.04	13550.0
2015-01-29 09:00:00	DIA	ETF	172.14	172.41	171.34	171.98	1491968.0
2015-01-29 10:00:00	DIA	ETF	171.98	172.28	171.06	171.57	1915251.0
2015-01-29 11:00:00	DIA	ETF	171.57	172.335	171.35	172.05	1369526.0

> showing 50 of 7,654 rows — these rows as CSV

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