PREVIEW / etf_1hour / 2019-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-07.parquet
  size:    327 KB
  rows:    10,788

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
2019-02-07 04:00:00	SPY	ETF	272.11	272.17	272.02	272.17	13208.0
2019-02-07 05:00:00	SPY	ETF	272.05	272.05	271.22	271.4	56254.0
2019-02-07 06:00:00	SPY	ETF	271.34	271.45	270.72	270.92	242526.0
2019-02-07 07:00:00	SPY	ETF	270.94	271.28	270.82	270.9	355728.0
2019-02-07 08:00:00	SPY	ETF	270.95	272.74	270.65	271.18	733996.0
2019-02-07 09:00:00	SPY	ETF	271.17	271.26	270.38	270.75	9235282.0
2019-02-07 10:00:00	SPY	ETF	270.755	271.55	269.84	269.88	12076268.0
2019-02-07 11:00:00	SPY	ETF	269.88	270.07	268.49	268.56	16884050.0
2019-02-07 12:00:00	SPY	ETF	268.54	269.29	268.29	268.57	9653022.0
2019-02-07 13:00:00	SPY	ETF	268.56	269.73	268.52	269.43	8317587.0
2019-02-07 14:00:00	SPY	ETF	269.42	269.69	268.67	269.31	10658565.0
2019-02-07 15:00:00	SPY	ETF	269.3	270.25	269.04	270.19	19445917.0
2019-02-07 16:00:00	SPY	ETF	270.18	270.31	269.21	270.03	6352039.0
2019-02-07 17:00:00	SPY	ETF	270.04	270.14	269.75	269.89	279261.0
2019-02-07 18:00:00	SPY	ETF	269.89	269.99	269.44	269.53	268475.0
2019-02-07 19:00:00	SPY	ETF	269.45	269.7	269.36	269.46	61827.0
2019-02-07 04:00:00	QQQ	ETF	169.87	170.0	169.81	170.0	39872.0
2019-02-07 05:00:00	QQQ	ETF	169.97	170.02	169.3	169.46	79358.0
2019-02-07 06:00:00	QQQ	ETF	169.41	169.49	169.16	169.27	48996.0
2019-02-07 07:00:00	QQQ	ETF	169.29	169.47	169.2	169.24	207341.0
2019-02-07 08:00:00	QQQ	ETF	169.22	169.88	169.02	169.34	397590.0
2019-02-07 09:00:00	QQQ	ETF	169.29	169.36	168.33	168.82	4985473.0
2019-02-07 10:00:00	QQQ	ETF	168.83	169.4499	168.25	168.2799	5171041.0
2019-02-07 11:00:00	QQQ	ETF	168.27	168.535	167.21	167.22	7591443.0
2019-02-07 12:00:00	QQQ	ETF	167.22	167.78	166.95	167.24	4883099.0
2019-02-07 13:00:00	QQQ	ETF	167.24	168.0099	167.21	167.79	4197609.0
2019-02-07 14:00:00	QQQ	ETF	167.79	168.0353	167.28	167.71	3759593.0
2019-02-07 15:00:00	QQQ	ETF	167.7	168.25	167.46	168.24	5580516.0
2019-02-07 16:00:00	QQQ	ETF	168.24	168.35	168.05	168.1	1100686.0
2019-02-07 17:00:00	QQQ	ETF	168.1	168.16	168.05	168.05	22886.0
2019-02-07 18:00:00	QQQ	ETF	168.01	168.01	167.5601	167.6	67761.0
2019-02-07 19:00:00	QQQ	ETF	167.61	167.78	167.55	167.62	37556.0
2019-02-07 04:00:00	IWM	ETF	150.57	150.57	150.54	150.54	400.0
2019-02-07 05:00:00	IWM	ETF	150.3	150.3	150.08	150.08	5055.0
2019-02-07 06:00:00	IWM	ETF	149.92	150.05	149.92	150.0	123700.0
2019-02-07 07:00:00	IWM	ETF	150.0	150.13	149.92	149.93	36570.0
2019-02-07 08:00:00	IWM	ETF	150.0	150.93	149.75	150.1	388635.0
2019-02-07 09:00:00	IWM	ETF	150.07	150.29	149.765	150.23	2205550.0
2019-02-07 10:00:00	IWM	ETF	150.24	150.7028	149.26	149.31	2972827.0
2019-02-07 11:00:00	IWM	ETF	149.31	149.38	148.39	148.77	3376075.0
2019-02-07 12:00:00	IWM	ETF	148.76	149.35	148.53	148.975	2207878.0
2019-02-07 13:00:00	IWM	ETF	148.94	149.76	148.92	149.6	1528328.0
2019-02-07 14:00:00	IWM	ETF	149.59	149.68	149.13	149.44	1338624.0
2019-02-07 15:00:00	IWM	ETF	149.425	149.9	149.29	149.72	3101266.0
2019-02-07 16:00:00	IWM	ETF	149.71	150.9505	147.75	149.52	1244925.0
2019-02-07 17:00:00	IWM	ETF	149.52	149.69	149.5	149.5	88079.0
2019-02-07 18:00:00	IWM	ETF	149.49	149.49	149.21	149.23	9830.0
2019-02-07 19:00:00	IWM	ETF	149.21	149.29	149.21	149.25	4900.0
2019-02-07 05:00:00	DIA	ETF	253.02	253.02	252.66	252.66	3100.0
2019-02-07 06:00:00	DIA	ETF	252.4	252.41	252.28	252.35	800.0

> showing 50 of 10,788 rows — these rows as CSV

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