PREVIEW / etf_1hour / 2014-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-30.parquet
  size:    226 KB
  rows:    7,126

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
2014-10-30 04:00:00	SPY	ETF	198.41	198.52	198.1	198.16	34642.0
2014-10-30 05:00:00	SPY	ETF	198.03	198.06	197.02	197.2	104276.0
2014-10-30 06:00:00	SPY	ETF	197.32	197.4	196.74	196.96	251884.0
2014-10-30 07:00:00	SPY	ETF	196.92	197.04	196.52	196.93	1056654.0
2014-10-30 08:00:00	SPY	ETF	196.93	198.59	196.58	197.12	2168503.0
2014-10-30 09:00:00	SPY	ETF	197.11	198.38	196.72	197.65	16420381.0
2014-10-30 10:00:00	SPY	ETF	197.64	198.31	197.4	198.29	14529622.0
2014-10-30 11:00:00	SPY	ETF	198.29	198.8	198.21	198.74	12343059.0
2014-10-30 12:00:00	SPY	ETF	198.74	198.99	198.52	198.87	7952089.0
2014-10-30 13:00:00	SPY	ETF	198.875	199.91	198.86	199.786	12556521.0
2014-10-30 14:00:00	SPY	ETF	199.79	199.95	198.66	198.7857	19628531.0
2014-10-30 15:00:00	SPY	ETF	198.79	199.49	198.7	199.45	19476841.0
2014-10-30 16:00:00	SPY	ETF	199.44	199.49	199.31	199.45	7539048.0
2014-10-30 17:00:00	SPY	ETF	199.44	199.45	199.29	199.3	326866.0
2014-10-30 18:00:00	SPY	ETF	199.32	199.49	199.22	199.45	220608.0
2014-10-30 19:00:00	SPY	ETF	199.42	199.55	199.38	199.52	86031.0
2014-10-30 04:00:00	QQQ	ETF	99.68	99.68	99.62	99.62	300.0
2014-10-30 05:00:00	QQQ	ETF	99.6	99.6	99.15	99.16	40630.0
2014-10-30 06:00:00	QQQ	ETF	99.3	99.32	99.03	99.1	64350.0
2014-10-30 07:00:00	QQQ	ETF	99.09	99.13	98.81	99.03	255522.0
2014-10-30 08:00:00	QQQ	ETF	99.02	99.31	99.02	99.13	280065.0
2014-10-30 09:00:00	QQQ	ETF	99.16	99.8	99.16	99.34	4837441.0
2014-10-30 10:00:00	QQQ	ETF	99.32	99.54	99.14	99.43	4595630.0
2014-10-30 11:00:00	QQQ	ETF	99.42	99.69	99.37	99.67	2663510.0
2014-10-30 12:00:00	QQQ	ETF	99.68	99.84	99.55	99.764	1802225.0
2014-10-30 13:00:00	QQQ	ETF	99.77	100.25	99.73	100.17	4301003.0
2014-10-30 14:00:00	QQQ	ETF	100.18	100.26	99.545	99.6267	3970018.0
2014-10-30 15:00:00	QQQ	ETF	99.62	100.06	99.59	100.03	5544415.0
2014-10-30 16:00:00	QQQ	ETF	100.03	100.12	99.6192	100.05	1504488.0
2014-10-30 17:00:00	QQQ	ETF	100.02	100.05	99.95	99.96	16251.0
2014-10-30 18:00:00	QQQ	ETF	99.96	100.06	99.96	100.06	5545.0
2014-10-30 19:00:00	QQQ	ETF	100.07	100.13	100.03	100.09	13800.0
2014-10-30 04:00:00	IWM	ETF	114.0	114.0	114.0	114.0	280.0
2014-10-30 05:00:00	IWM	ETF	113.15	113.15	113.15	113.15	196.0
2014-10-30 06:00:00	IWM	ETF	112.99	112.99	112.58	112.58	5400.0
2014-10-30 07:00:00	IWM	ETF	112.95	112.95	112.78	112.93	127523.0
2014-10-30 08:00:00	IWM	ETF	112.85	113.41	112.85	113.17	681198.0
2014-10-30 09:00:00	IWM	ETF	113.2	114.25	113.19	113.4	5617222.0
2014-10-30 10:00:00	IWM	ETF	113.39	113.94	113.14	113.89	6250290.0
2014-10-30 11:00:00	IWM	ETF	113.88	114.04	113.55	113.975	3286149.0
2014-10-30 12:00:00	IWM	ETF	113.98	114.37	113.78	114.11	3379404.0
2014-10-30 13:00:00	IWM	ETF	114.115	114.75	114.01	114.665	2608458.0
2014-10-30 14:00:00	IWM	ETF	115.02	115.04	114.32	114.39	2401652.0
2014-10-30 15:00:00	IWM	ETF	114.4	114.92	114.27	114.89	8419023.0
2014-10-30 16:00:00	IWM	ETF	114.89	115.04	113.9024	115.04	4330200.0
2014-10-30 17:00:00	IWM	ETF	115.04	115.04	114.91	114.91	10849.0
2014-10-30 18:00:00	IWM	ETF	114.9	114.94	114.9	114.9	6100.0
2014-10-30 19:00:00	IWM	ETF	114.9	115.08	114.86	115.08	2400.0
2014-10-30 05:00:00	DIA	ETF	169.35	169.35	169.09	169.09	17000.0
2014-10-30 06:00:00	DIA	ETF	169.3	169.3	168.99	168.99	18100.0

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

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