PREVIEW / etf_1hour / 2018-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-10.parquet
  size:    300 KB
  rows:    9,829

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
2018-05-10 04:00:00	SPY	ETF	270.03	270.11	269.94	270.01	16570.0
2018-05-10 05:00:00	SPY	ETF	270.06	270.13	269.7	269.8	7271.0
2018-05-10 06:00:00	SPY	ETF	269.71	269.83	269.58	269.66	17601.0
2018-05-10 07:00:00	SPY	ETF	269.73	270.12	269.58	270.07	176451.0
2018-05-10 08:00:00	SPY	ETF	269.66	270.57	269.66	270.37	773047.0
2018-05-10 09:00:00	SPY	ETF	270.33	270.81	270.19	270.62	5539274.0
2018-05-10 10:00:00	SPY	ETF	270.62	271.12	270.28	270.945	8554589.0
2018-05-10 11:00:00	SPY	ETF	270.95	271.71	270.89	271.665	7297809.0
2018-05-10 12:00:00	SPY	ETF	271.665	272.26	271.61	272.06	7264532.0
2018-05-10 13:00:00	SPY	ETF	272.07	272.39	271.55	271.72	7738236.0
2018-05-10 14:00:00	SPY	ETF	271.73	272.06	271.2	271.95	7218833.0
2018-05-10 15:00:00	SPY	ETF	271.95	272.23	271.575	272.01	14942451.0
2018-05-10 16:00:00	SPY	ETF	272.01	272.0616	270.3	271.55	9824650.0
2018-05-10 17:00:00	SPY	ETF	271.56	272.02	271.48	271.53	447182.0
2018-05-10 18:00:00	SPY	ETF	271.58	271.87	271.58	271.69	959197.0
2018-05-10 19:00:00	SPY	ETF	271.7	271.93	271.7	271.93	16991.0
2018-05-10 04:00:00	QQQ	ETF	168.2	168.32	168.19	168.23	20731.0
2018-05-10 05:00:00	QQQ	ETF	168.29	168.29	168.0	168.15	10030.0
2018-05-10 06:00:00	QQQ	ETF	168.18	168.18	168.06	168.08	12100.0
2018-05-10 07:00:00	QQQ	ETF	168.13	168.29	168.03	168.19	117566.0
2018-05-10 08:00:00	QQQ	ETF	167.88	168.57	167.88	168.47	371139.0
2018-05-10 09:00:00	QQQ	ETF	168.45	168.8	168.29	168.62	2397979.0
2018-05-10 10:00:00	QQQ	ETF	168.64	169.08	168.42	168.97	3089124.0
2018-05-10 11:00:00	QQQ	ETF	168.96	169.25	168.93	169.15	2336795.0
2018-05-10 12:00:00	QQQ	ETF	169.15	169.48	169.1	169.44	2515904.0
2018-05-10 13:00:00	QQQ	ETF	169.44	169.72	169.07	169.21	2665621.0
2018-05-10 14:00:00	QQQ	ETF	169.22	169.44	168.9	169.37	2510316.0
2018-05-10 15:00:00	QQQ	ETF	169.37	169.74	169.13	169.62	5859297.0
2018-05-10 16:00:00	QQQ	ETF	169.62	169.73	169.3	169.3	1132120.0
2018-05-10 17:00:00	QQQ	ETF	169.43	169.43	169.21	169.21	8520.0
2018-05-10 18:00:00	QQQ	ETF	169.22	169.51	169.18	169.38	16423.0
2018-05-10 19:00:00	QQQ	ETF	169.39	169.52	169.38	169.52	24006.0
2018-05-10 05:00:00	IWM	ETF	159.0	159.0	158.86	158.86	2500.0
2018-05-10 06:00:00	IWM	ETF	158.82	158.82	158.78	158.81	15000.0
2018-05-10 07:00:00	IWM	ETF	158.8	158.98	158.8	158.98	7510.0
2018-05-10 08:00:00	IWM	ETF	158.83	159.12	158.75	158.97	36661.0
2018-05-10 09:00:00	IWM	ETF	158.88	159.26	158.75	159.16	1474306.0
2018-05-10 10:00:00	IWM	ETF	159.17	159.44	158.87	159.365	1801719.0
2018-05-10 11:00:00	IWM	ETF	159.37	159.93	159.33	159.88	1537371.0
2018-05-10 12:00:00	IWM	ETF	159.87	160.13	159.82	160.04	1197116.0
2018-05-10 13:00:00	IWM	ETF	160.04	160.17	159.54	159.61	1665222.0
2018-05-10 14:00:00	IWM	ETF	159.62	159.86	159.34	159.63	1738542.0
2018-05-10 15:00:00	IWM	ETF	159.64	159.66	159.36	159.49	3657931.0
2018-05-10 16:00:00	IWM	ETF	159.49	159.59	159.42	159.49	964176.0
2018-05-10 17:00:00	IWM	ETF	159.49	159.49	159.4	159.4	3366.0
2018-05-10 18:00:00	IWM	ETF	159.46	159.62	159.46	159.53	17196.0
2018-05-10 19:00:00	IWM	ETF	159.59	159.69	159.54	159.69	4050.0
2018-05-10 04:00:00	DIA	ETF	245.76	245.76	245.76	245.76	100.0
2018-05-10 05:00:00	DIA	ETF	245.65	245.65	245.65	245.65	100.0
2018-05-10 07:00:00	DIA	ETF	245.46	245.7	245.3	245.7	4809.0

> showing 50 of 9,829 rows — these rows as CSV

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