PREVIEW / etf_1hour / 2018-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-15.parquet
  size:    301 KB
  rows:    9,959

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-15 04:00:00	SPY	ETF	272.63	272.63	272.28	272.3	11220.0
2018-05-15 05:00:00	SPY	ETF	272.44	272.75	272.44	272.74	2800.0
2018-05-15 06:00:00	SPY	ETF	272.66	272.8	272.66	272.67	25680.0
2018-05-15 07:00:00	SPY	ETF	272.64	272.74	272.18	272.31	151001.0
2018-05-15 08:00:00	SPY	ETF	272.25	272.98	271.18	271.44	1424478.0
2018-05-15 09:00:00	SPY	ETF	271.45	271.67	270.29	270.37	11532478.0
2018-05-15 10:00:00	SPY	ETF	270.35	271.52	270.3	270.95	9509382.0
2018-05-15 11:00:00	SPY	ETF	270.94	271.32	270.6	270.65	5849969.0
2018-05-15 12:00:00	SPY	ETF	270.659	271.39	270.28	270.99	7828110.0
2018-05-15 13:00:00	SPY	ETF	270.99	271.06	270.08	270.11	6649759.0
2018-05-15 14:00:00	SPY	ETF	270.11	271.16	270.07	270.51	9695583.0
2018-05-15 15:00:00	SPY	ETF	270.52	271.1	270.03	271.03	21330602.0
2018-05-15 16:00:00	SPY	ETF	271.04	271.2	270.7031	270.93	8536045.0
2018-05-15 17:00:00	SPY	ETF	270.99	271.02	270.92	271.01	66392.0
2018-05-15 18:00:00	SPY	ETF	271.03	271.09	270.6	270.66	91082.0
2018-05-15 19:00:00	SPY	ETF	270.68	270.7	270.42	270.64	60945.0
2018-05-15 04:00:00	QQQ	ETF	169.47	169.47	169.35	169.41	3080.0
2018-05-15 05:00:00	QQQ	ETF	169.38	169.59	169.38	169.59	14589.0
2018-05-15 06:00:00	QQQ	ETF	169.55	169.63	169.51	169.51	10079.0
2018-05-15 07:00:00	QQQ	ETF	169.51	169.57	169.07	169.15	59200.0
2018-05-15 08:00:00	QQQ	ETF	169.38	169.75	168.19	168.33	845810.0
2018-05-15 09:00:00	QQQ	ETF	168.3	168.5	167.1	167.19	7606232.0
2018-05-15 10:00:00	QQQ	ETF	167.18	168.29	167.1	167.55	7461791.0
2018-05-15 11:00:00	QQQ	ETF	167.55	167.86	167.275	167.45	3658258.0
2018-05-15 12:00:00	QQQ	ETF	167.46	167.93	167.16	167.64	2859221.0
2018-05-15 13:00:00	QQQ	ETF	167.63	167.73	167.02	167.065	4175387.0
2018-05-15 14:00:00	QQQ	ETF	167.05	167.85	166.98	167.46	3870809.0
2018-05-15 15:00:00	QQQ	ETF	167.47	167.94	167.13	167.89	6713856.0
2018-05-15 16:00:00	QQQ	ETF	167.89	168.0	167.84	167.89	2250473.0
2018-05-15 17:00:00	QQQ	ETF	167.69	167.87	167.69	167.87	10433.0
2018-05-15 18:00:00	QQQ	ETF	167.9	167.96	167.67	167.68	15743.0
2018-05-15 19:00:00	QQQ	ETF	167.64	167.7	167.5	167.7	20227.0
2018-05-15 04:00:00	IWM	ETF	159.07	159.07	159.0	159.0	200.0
2018-05-15 05:00:00	IWM	ETF	159.18	159.18	159.18	159.18	500.0
2018-05-15 06:00:00	IWM	ETF	159.21	159.21	159.21	159.21	2500.0
2018-05-15 07:00:00	IWM	ETF	159.21	159.21	158.93	159.0	26708.0
2018-05-15 08:00:00	IWM	ETF	159.02	159.09	158.28	158.5	125645.0
2018-05-15 09:00:00	IWM	ETF	158.5	158.9	158.23	158.26	2794637.0
2018-05-15 10:00:00	IWM	ETF	158.26	159.32	158.17	159.155	2988888.0
2018-05-15 11:00:00	IWM	ETF	159.16	159.5899	159.16	159.3	1763534.0
2018-05-15 12:00:00	IWM	ETF	159.29	159.43	158.89	159.23	1302884.0
2018-05-15 13:00:00	IWM	ETF	159.24	159.28	158.91	158.93	1102491.0
2018-05-15 14:00:00	IWM	ETF	158.92	159.39	158.85	159.12	1329552.0
2018-05-15 15:00:00	IWM	ETF	159.13	159.3	158.96	159.28	3123731.0
2018-05-15 16:00:00	IWM	ETF	159.1962	159.35	159.14	159.25	1405450.0
2018-05-15 17:00:00	IWM	ETF	159.26	159.26	159.2	159.26	2507.0
2018-05-15 18:00:00	IWM	ETF	159.3	159.3	159.06	159.06	6170.0
2018-05-15 19:00:00	IWM	ETF	159.06	159.08	158.95	159.05	2966.0
2018-05-15 07:00:00	DIA	ETF	248.8	248.8	248.4	248.45	2256.0
2018-05-15 08:00:00	DIA	ETF	248.43	248.65	247.51	247.74	41601.0

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

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