PREVIEW / etf_1hour / 2018-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-25.parquet
  size:    312 KB
  rows:    10,291

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-06-25 04:00:00	SPY	ETF	273.5	273.79	273.19	273.19	41601.0
2018-06-25 05:00:00	SPY	ETF	273.25	273.41	273.1	273.36	32360.0
2018-06-25 06:00:00	SPY	ETF	273.42	273.5	272.93	273.3	209607.0
2018-06-25 07:00:00	SPY	ETF	273.27	273.63	273.21	273.6	278587.0
2018-06-25 08:00:00	SPY	ETF	273.6	273.74	273.2	273.6	453737.0
2018-06-25 09:00:00	SPY	ETF	273.6	273.64	271.98	272.03	10900108.0
2018-06-25 10:00:00	SPY	ETF	272.02	272.2	271.06	271.5554	19683490.0
2018-06-25 11:00:00	SPY	ETF	271.55	271.72	270.2	270.625	16083673.0
2018-06-25 12:00:00	SPY	ETF	270.62	270.86	269.45	270.805	13520627.0
2018-06-25 13:00:00	SPY	ETF	270.8	271.21	269.97	270.73	9951400.0
2018-06-25 14:00:00	SPY	ETF	270.73	270.88	269.1	269.58	11165148.0
2018-06-25 15:00:00	SPY	ETF	269.58	271.51	269.3	271.01	31985891.0
2018-06-25 16:00:00	SPY	ETF	271.01	271.37	270.45	271.26	18924266.0
2018-06-25 17:00:00	SPY	ETF	271.21	271.25	270.5581	271.05	1112274.0
2018-06-25 18:00:00	SPY	ETF	271.12	271.38	271.12	271.25	364754.0
2018-06-25 19:00:00	SPY	ETF	271.26	271.4	271.02	271.08	39591.0
2018-06-25 04:00:00	QQQ	ETF	174.72	174.72	173.87	173.88	43313.0
2018-06-25 05:00:00	QQQ	ETF	173.83	174.0	173.61	173.69	37231.0
2018-06-25 06:00:00	QQQ	ETF	173.73	173.85	173.37	173.6	36092.0
2018-06-25 07:00:00	QQQ	ETF	173.6	173.97	173.57	173.77	167858.0
2018-06-25 08:00:00	QQQ	ETF	173.6	174.1	173.57	173.85	356050.0
2018-06-25 09:00:00	QQQ	ETF	173.85	173.99	172.57	172.75	6724620.0
2018-06-25 10:00:00	QQQ	ETF	172.74	172.995	171.75	171.88	11774786.0
2018-06-25 11:00:00	QQQ	ETF	171.89	172.055	170.9839	171.1838	7751026.0
2018-06-25 12:00:00	QQQ	ETF	171.18	171.26	170.07	170.82	8600713.0
2018-06-25 13:00:00	QQQ	ETF	170.825	171.13	170.16	170.72	7105424.0
2018-06-25 14:00:00	QQQ	ETF	170.72	170.86	169.81	170.17	4973490.0
2018-06-25 15:00:00	QQQ	ETF	170.165	171.68	170.02	171.36	15069478.0
2018-06-25 16:00:00	QQQ	ETF	171.37	171.75	171.0501	171.55	3329426.0
2018-06-25 17:00:00	QQQ	ETF	171.43	171.55	171.37	171.45	329481.0
2018-06-25 18:00:00	QQQ	ETF	171.47	171.67	171.45	171.52	85038.0
2018-06-25 19:00:00	QQQ	ETF	171.58	171.63	171.29	171.36	29920.0
2018-06-25 04:00:00	IWM	ETF	167.23	167.27	167.12	167.12	6338.0
2018-06-25 05:00:00	IWM	ETF	167.06	167.06	167.06	167.06	100.0
2018-06-25 06:00:00	IWM	ETF	167.16	167.16	167.05	167.14	4300.0
2018-06-25 07:00:00	IWM	ETF	167.27	167.43	167.25	167.35	66797.0
2018-06-25 08:00:00	IWM	ETF	167.3301	167.43	167.23	167.31	26328.0
2018-06-25 09:00:00	IWM	ETF	167.36	167.37	165.53	165.6	3810549.0
2018-06-25 10:00:00	IWM	ETF	165.57	165.94	165.25	165.42	5522225.0
2018-06-25 11:00:00	IWM	ETF	165.42	165.48	164.43	164.72	4344445.0
2018-06-25 12:00:00	IWM	ETF	164.715	165.14	164.14	165.105	3072094.0
2018-06-25 13:00:00	IWM	ETF	165.11	166.05	164.84	165.68	3754816.0
2018-06-25 14:00:00	IWM	ETF	165.68	165.79	164.53	164.72	4523448.0
2018-06-25 15:00:00	IWM	ETF	164.725	165.37	164.4	165.09	7653808.0
2018-06-25 16:00:00	IWM	ETF	165.11	165.31	164.75	165.3	918835.0
2018-06-25 17:00:00	IWM	ETF	165.3	165.34	165.08	165.3	142937.0
2018-06-25 18:00:00	IWM	ETF	165.19	165.4	165.08	165.4	14200.0
2018-06-25 19:00:00	IWM	ETF	165.39	165.45	165.21	165.21	10863.0
2018-06-25 04:00:00	DIA	ETF	244.5	245.14	244.23	244.23	820.0
2018-06-25 06:00:00	DIA	ETF	244.0	244.0	243.78	243.92	3950.0

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

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