PREVIEW / etf_1hour / 2016-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-22.parquet
  size:    249 KB
  rows:    8,032

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
2016-02-22 04:00:00	SPY	ETF	193.65	194.43	193.5	194.43	75405.0
2016-02-22 05:00:00	SPY	ETF	194.39	194.43	194.11	194.15	78856.0
2016-02-22 06:00:00	SPY	ETF	194.18	194.37	194.14	194.2	96243.0
2016-02-22 07:00:00	SPY	ETF	194.2	194.2	193.84	194.03	275017.0
2016-02-22 08:00:00	SPY	ETF	194.0	194.24	193.01	194.21	992251.0
2016-02-22 09:00:00	SPY	ETF	194.21	194.62	193.79	194.52	14237510.0
2016-02-22 10:00:00	SPY	ETF	194.52	194.87	194.27	194.345	14976377.0
2016-02-22 11:00:00	SPY	ETF	194.3389	194.56	194.17	194.53	7641152.0
2016-02-22 12:00:00	SPY	ETF	194.53	194.71	194.28	194.33	7002376.0
2016-02-22 13:00:00	SPY	ETF	194.3299	194.95	194.28	194.85	6988737.0
2016-02-22 14:00:00	SPY	ETF	194.8475	194.87	194.33	194.47	8443913.0
2016-02-22 15:00:00	SPY	ETF	194.47	194.8	194.2	194.79	27176543.0
2016-02-22 16:00:00	SPY	ETF	194.77	194.83	193.91	193.92	8577267.0
2016-02-22 17:00:00	SPY	ETF	193.96	194.1	193.82	194.0	550689.0
2016-02-22 18:00:00	SPY	ETF	194.02	194.15	193.91	193.93	167715.0
2016-02-22 19:00:00	SPY	ETF	194.0	194.11	193.85	193.92	103679.0
2016-02-22 04:00:00	QQQ	ETF	102.36	103.0	102.36	103.0	7874.0
2016-02-22 05:00:00	QQQ	ETF	102.99	102.99	102.87	102.87	900.0
2016-02-22 06:00:00	QQQ	ETF	102.88	102.96	102.85	102.86	25420.0
2016-02-22 07:00:00	QQQ	ETF	102.81	102.81	102.69	102.74	49095.0
2016-02-22 08:00:00	QQQ	ETF	102.75	102.83	102.64	102.69	176515.0
2016-02-22 09:00:00	QQQ	ETF	102.7	103.07	102.48	103.03	4458745.0
2016-02-22 10:00:00	QQQ	ETF	103.02	103.2199	102.72	102.83	3376657.0
2016-02-22 11:00:00	QQQ	ETF	102.83	103.19	102.75	103.17	2090915.0
2016-02-22 12:00:00	QQQ	ETF	103.17	103.29	102.98	103.01	1376168.0
2016-02-22 13:00:00	QQQ	ETF	103.01	103.38	103.0	103.29	1400341.0
2016-02-22 14:00:00	QQQ	ETF	103.3	103.31	103.03	103.09	1910022.0
2016-02-22 15:00:00	QQQ	ETF	103.0887	103.28	102.87	103.27	5039702.0
2016-02-22 16:00:00	QQQ	ETF	103.27	103.28	102.77	102.77	961283.0
2016-02-22 17:00:00	QQQ	ETF	102.83	102.87	102.75	102.77	18503.0
2016-02-22 18:00:00	QQQ	ETF	102.75	102.87	102.75	102.81	43607.0
2016-02-22 19:00:00	QQQ	ETF	102.8	102.88	102.73	102.73	17662.0
2016-02-22 04:00:00	IWM	ETF	101.35	101.5	101.35	101.5	2659.0
2016-02-22 05:00:00	IWM	ETF	101.73	101.73	101.73	101.73	100.0
2016-02-22 06:00:00	IWM	ETF	101.8	101.8	101.64	101.64	5900.0
2016-02-22 07:00:00	IWM	ETF	101.59	101.59	101.45	101.51	75828.0
2016-02-22 08:00:00	IWM	ETF	101.52	101.6	101.45	101.57	140521.0
2016-02-22 09:00:00	IWM	ETF	101.5	102.01	101.24	101.77	4074426.0
2016-02-22 10:00:00	IWM	ETF	101.77	101.97	101.44	101.46	4117298.0
2016-02-22 11:00:00	IWM	ETF	101.465	101.74	101.33	101.68	1674170.0
2016-02-22 12:00:00	IWM	ETF	101.68	101.775	101.5	101.55	1525294.0
2016-02-22 13:00:00	IWM	ETF	101.54	102.0	101.51	101.9	1673631.0
2016-02-22 14:00:00	IWM	ETF	101.9	101.93	101.67	101.82	1776171.0
2016-02-22 15:00:00	IWM	ETF	101.83	101.875	101.42	101.57	6888467.0
2016-02-22 16:00:00	IWM	ETF	101.58	101.5911	101.08	101.08	1086711.0
2016-02-22 17:00:00	IWM	ETF	101.09	101.13	101.06	101.07	9353.0
2016-02-22 18:00:00	IWM	ETF	101.25	101.25	101.05	101.05	1401.0
2016-02-22 19:00:00	IWM	ETF	101.07	101.07	101.05	101.05	800.0
2016-02-22 04:00:00	DIA	ETF	165.12	165.12	165.12	165.12	195.0
2016-02-22 08:00:00	DIA	ETF	165.6	165.6	165.38	165.58	9415.0

> showing 50 of 8,032 rows — these rows as CSV

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