PREVIEW / etf_1hour / 2018-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-28.parquet
  size:    302 KB
  rows:    9,939

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-28 04:00:00	SPY	ETF	270.3	270.82	269.94	270.16	50972.0
2018-06-28 05:00:00	SPY	ETF	270.19	270.19	269.59	270.06	38602.0
2018-06-28 06:00:00	SPY	ETF	269.99	270.69	269.99	270.17	121800.0
2018-06-28 07:00:00	SPY	ETF	270.18	270.23	269.6	269.85	188794.0
2018-06-28 08:00:00	SPY	ETF	269.77	270.56	268.46	268.64	1541134.0
2018-06-28 09:00:00	SPY	ETF	268.66	269.86	268.5772	269.44	10822099.0
2018-06-28 10:00:00	SPY	ETF	269.47	269.98	268.49	269.93	13875341.0
2018-06-28 11:00:00	SPY	ETF	269.93	270.5	269.24	270.13	10361904.0
2018-06-28 12:00:00	SPY	ETF	270.15	270.29	269.16	269.95	5409649.0
2018-06-28 13:00:00	SPY	ETF	269.96	270.49	269.86	270.41	4923614.0
2018-06-28 14:00:00	SPY	ETF	270.4	271.42	270.28	271.39	8341200.0
2018-06-28 15:00:00	SPY	ETF	271.39	271.75	270.77	270.95	14927337.0
2018-06-28 16:00:00	SPY	ETF	270.94	271.24	270.76	271.19	4289226.0
2018-06-28 17:00:00	SPY	ETF	271.19	271.3	271.16	271.2	144615.0
2018-06-28 18:00:00	SPY	ETF	271.2	271.34	270.98	271.01	76446.0
2018-06-28 19:00:00	SPY	ETF	270.98	271.28	270.97	271.25	12075.0
2018-06-28 04:00:00	QQQ	ETF	170.57	170.84	170.1	170.32	34624.0
2018-06-28 05:00:00	QQQ	ETF	170.33	170.36	169.92	170.25	45590.0
2018-06-28 06:00:00	QQQ	ETF	170.24	170.63	170.11	170.28	32439.0
2018-06-28 07:00:00	QQQ	ETF	170.29	170.32	169.87	170.09	199010.0
2018-06-28 08:00:00	QQQ	ETF	170.19	170.29	168.87	169.09	766477.0
2018-06-28 09:00:00	QQQ	ETF	169.12	170.5	169.11	170.17	7370353.0
2018-06-28 10:00:00	QQQ	ETF	170.24	170.55	169.17	170.53	9001014.0
2018-06-28 11:00:00	QQQ	ETF	170.53	170.92	170.051	170.62	5339374.0
2018-06-28 12:00:00	QQQ	ETF	170.63	170.73	169.84	170.39	3301310.0
2018-06-28 13:00:00	QQQ	ETF	170.39	170.71	170.305	170.61	2641947.0
2018-06-28 14:00:00	QQQ	ETF	170.63	171.56	170.54	171.5599	4042861.0
2018-06-28 15:00:00	QQQ	ETF	171.55	171.77	171.07	171.19	6278480.0
2018-06-28 16:00:00	QQQ	ETF	171.18	171.7034	171.16	171.33	1064691.0
2018-06-28 17:00:00	QQQ	ETF	171.38	171.48	171.3	171.35	8974.0
2018-06-28 18:00:00	QQQ	ETF	171.3	171.47	171.18	171.2	43005.0
2018-06-28 19:00:00	QQQ	ETF	171.19	171.42	171.16	171.42	18012.0
2018-06-28 05:00:00	IWM	ETF	163.74	163.74	163.59	163.68	3200.0
2018-06-28 06:00:00	IWM	ETF	163.68	163.93	163.68	163.93	1400.0
2018-06-28 07:00:00	IWM	ETF	163.67	163.67	163.39	163.5	29482.0
2018-06-28 08:00:00	IWM	ETF	163.49	163.49	162.72	162.79	148739.0
2018-06-28 09:00:00	IWM	ETF	162.82	163.6	162.49	163.28	3175004.0
2018-06-28 10:00:00	IWM	ETF	163.28	163.55	162.26	163.405	4894848.0
2018-06-28 11:00:00	IWM	ETF	163.41	163.51	162.8	163.18	3094009.0
2018-06-28 12:00:00	IWM	ETF	163.19	163.34	162.64	163.295	1866891.0
2018-06-28 13:00:00	IWM	ETF	163.295	163.78	163.28	163.66	3290522.0
2018-06-28 14:00:00	IWM	ETF	163.65	164.12	163.62	164.1	2472000.0
2018-06-28 15:00:00	IWM	ETF	164.1	164.22	163.68	163.87	3860359.0
2018-06-28 16:00:00	IWM	ETF	163.85	164.14	163.79	164.07	643692.0
2018-06-28 17:00:00	IWM	ETF	164.1	164.12	164.08	164.12	1400.0
2018-06-28 18:00:00	IWM	ETF	164.07	164.15	163.97	163.99	16960.0
2018-06-28 19:00:00	IWM	ETF	164.09	164.17	164.01	164.17	2184.0
2018-06-28 04:00:00	DIA	ETF	241.82	242.27	241.82	241.83	1112.0
2018-06-28 06:00:00	DIA	ETF	241.89	241.89	241.89	241.89	700.0
2018-06-28 07:00:00	DIA	ETF	241.55	241.59	241.35	241.35	1410.0

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

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