PREVIEW / etf_1hour / 2018-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-27.parquet
  size:    310 KB
  rows:    10,255

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-27 04:00:00	SPY	ETF	270.0	270.4	269.68	269.75	88776.0
2018-06-27 05:00:00	SPY	ETF	269.76	271.15	269.76	271.05	51448.0
2018-06-27 06:00:00	SPY	ETF	271.14	271.21	270.78	270.84	48350.0
2018-06-27 07:00:00	SPY	ETF	270.85	272.15	270.31	271.85	1097353.0
2018-06-27 08:00:00	SPY	ETF	270.5601	272.42	270.06	271.89	1142224.0
2018-06-27 09:00:00	SPY	ETF	271.88	273.29	271.88	273.29	7278819.0
2018-06-27 10:00:00	SPY	ETF	273.28	273.865	272.97	273.35	10452138.0
2018-06-27 11:00:00	SPY	ETF	273.35	273.51	272.04	272.7989	11456972.0
2018-06-27 12:00:00	SPY	ETF	272.79	273.25	271.77	271.771	7514049.0
2018-06-27 13:00:00	SPY	ETF	271.78	272.05	270.45	270.87	11552658.0
2018-06-27 14:00:00	SPY	ETF	270.87	271.17	269.98	270.13	9745636.0
2018-06-27 15:00:00	SPY	ETF	270.13	270.645	269.18	269.27	30445213.0
2018-06-27 16:00:00	SPY	ETF	269.26	269.79	269.2349	269.61	11489023.0
2018-06-27 17:00:00	SPY	ETF	269.6	269.67	269.48	269.48	123579.0
2018-06-27 18:00:00	SPY	ETF	269.51	269.99	269.34	269.77	102453.0
2018-06-27 19:00:00	SPY	ETF	269.84	270.16	269.8	270.0	125525.0
2018-06-27 04:00:00	QQQ	ETF	170.8	170.84	170.21	170.31	42441.0
2018-06-27 05:00:00	QQQ	ETF	170.37	171.29	170.36	171.25	62036.0
2018-06-27 06:00:00	QQQ	ETF	171.28	171.3	171.02	171.15	39961.0
2018-06-27 07:00:00	QQQ	ETF	171.11	172.27	170.74	172.11	646492.0
2018-06-27 08:00:00	QQQ	ETF	172.17	172.75	170.78	172.27	825440.0
2018-06-27 09:00:00	QQQ	ETF	172.28	173.34	172.28	173.29	4113025.0
2018-06-27 10:00:00	QQQ	ETF	173.29	173.58	172.75	172.95	4743403.0
2018-06-27 11:00:00	QQQ	ETF	172.95	173.115	172.08	172.601	6065314.0
2018-06-27 12:00:00	QQQ	ETF	172.59	172.84	171.591	171.591	3643676.0
2018-06-27 13:00:00	QQQ	ETF	171.61	171.8	170.51	170.91	6852730.0
2018-06-27 14:00:00	QQQ	ETF	170.91	171.24	170.42	170.55	4411064.0
2018-06-27 15:00:00	QQQ	ETF	170.56	170.94	169.61	169.66	13235039.0
2018-06-27 16:00:00	QQQ	ETF	169.65	170.01	169.63	169.91	1938676.0
2018-06-27 17:00:00	QQQ	ETF	169.81	169.9	169.72	169.9	18477.0
2018-06-27 18:00:00	QQQ	ETF	169.81	170.21	169.73	170.08	46025.0
2018-06-27 19:00:00	QQQ	ETF	170.09	170.25	170.07	170.13	49993.0
2018-06-27 04:00:00	IWM	ETF	165.2	165.23	165.0	165.0	6584.0
2018-06-27 05:00:00	IWM	ETF	165.17	165.4	165.17	165.35	3454.0
2018-06-27 06:00:00	IWM	ETF	165.64	165.64	165.64	165.64	1503.0
2018-06-27 07:00:00	IWM	ETF	165.64	166.0	165.25	165.83	185793.0
2018-06-27 08:00:00	IWM	ETF	165.54	166.2	165.49	165.97	436474.0
2018-06-27 09:00:00	IWM	ETF	166.04	166.44	165.82	166.35	2283762.0
2018-06-27 10:00:00	IWM	ETF	166.33	166.51	165.99	166.03	2897681.0
2018-06-27 11:00:00	IWM	ETF	166.03	166.07	165.3	165.59	2760731.0
2018-06-27 12:00:00	IWM	ETF	165.59	165.87	165.03	165.06	1483798.0
2018-06-27 13:00:00	IWM	ETF	165.05	165.17	164.291	164.52	2682056.0
2018-06-27 14:00:00	IWM	ETF	164.53	164.76	163.97	164.05	2771797.0
2018-06-27 15:00:00	IWM	ETF	164.06	164.275	163.31	163.38	7462943.0
2018-06-27 16:00:00	IWM	ETF	163.37	163.55	163.29	163.43	1350101.0
2018-06-27 17:00:00	IWM	ETF	163.5	163.5	163.35	163.4	2211.0
2018-06-27 18:00:00	IWM	ETF	163.35	163.6	163.31	163.54	22575.0
2018-06-27 19:00:00	IWM	ETF	163.54	163.68	163.54	163.68	6716.0
2018-06-27 04:00:00	DIA	ETF	241.0	241.05	240.83	240.83	950.0
2018-06-27 05:00:00	DIA	ETF	241.24	241.24	241.24	241.24	400.0

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

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