PREVIEW / etf_1hour / 2018-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-06.parquet
  size:    307 KB
  rows:    10,174

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-11-06 04:00:00	SPY	ETF	273.24	273.48	272.88	272.92	28259.0
2018-11-06 05:00:00	SPY	ETF	272.81	273.22	272.67	272.75	64400.0
2018-11-06 06:00:00	SPY	ETF	272.83	273.25	272.83	273.03	29330.0
2018-11-06 07:00:00	SPY	ETF	273.02	273.24	272.83	273.16	126798.0
2018-11-06 08:00:00	SPY	ETF	273.06	273.92	272.84	272.99	290784.0
2018-11-06 09:00:00	SPY	ETF	273.02	274.82	273.02	274.6	5849653.0
2018-11-06 10:00:00	SPY	ETF	274.59	274.6601	273.86	274.39	6002993.0
2018-11-06 11:00:00	SPY	ETF	274.4	274.76	273.92	274.39	5217925.0
2018-11-06 12:00:00	SPY	ETF	274.42	274.99	274.25	274.71	4344846.0
2018-11-06 13:00:00	SPY	ETF	274.72	274.91	274.525	274.72	3668105.0
2018-11-06 14:00:00	SPY	ETF	274.71	274.74	273.45	273.96	8614914.0
2018-11-06 15:00:00	SPY	ETF	273.96	275.3	273.74	275.11	16149741.0
2018-11-06 16:00:00	SPY	ETF	275.1	275.71	274.2867	275.42	7881712.0
2018-11-06 17:00:00	SPY	ETF	275.42	275.53	275.35	275.35	258644.0
2018-11-06 18:00:00	SPY	ETF	275.35	275.55	274.75	274.97	822512.0
2018-11-06 19:00:00	SPY	ETF	274.96	275.49	274.19	275.0	208192.0
2018-11-06 04:00:00	QQQ	ETF	168.79	168.93	168.26	168.32	17067.0
2018-11-06 05:00:00	QQQ	ETF	168.3	168.58	168.15	168.29	21062.0
2018-11-06 06:00:00	QQQ	ETF	168.32	168.78	168.32	168.65	26621.0
2018-11-06 07:00:00	QQQ	ETF	168.65	168.78	168.41	168.74	33559.0
2018-11-06 08:00:00	QQQ	ETF	168.55	169.39	168.49	168.59	130253.0
2018-11-06 09:00:00	QQQ	ETF	168.59	171.19	168.59	170.86	5739012.0
2018-11-06 10:00:00	QQQ	ETF	170.84	170.9	169.77	169.87	4137179.0
2018-11-06 11:00:00	QQQ	ETF	169.88	170.2523	169.35	169.93	3676409.0
2018-11-06 12:00:00	QQQ	ETF	169.94	170.49	169.81	170.14	1939654.0
2018-11-06 13:00:00	QQQ	ETF	170.15	170.405	169.81	169.87	2147128.0
2018-11-06 14:00:00	QQQ	ETF	169.86	169.91	168.72	169.28	4074365.0
2018-11-06 15:00:00	QQQ	ETF	169.275	170.4	169.04	170.26	6277630.0
2018-11-06 16:00:00	QQQ	ETF	170.26	170.88	170.21	170.68	1096063.0
2018-11-06 17:00:00	QQQ	ETF	170.65	170.72	170.62	170.66	27120.0
2018-11-06 18:00:00	QQQ	ETF	170.63	170.76	170.24	170.3301	816382.0
2018-11-06 19:00:00	QQQ	ETF	170.31	170.77	169.75	170.21	113882.0
2018-11-06 04:00:00	IWM	ETF	153.51	153.51	153.51	153.51	500.0
2018-11-06 05:00:00	IWM	ETF	153.52	153.52	153.52	153.52	200.0
2018-11-06 07:00:00	IWM	ETF	153.65	153.65	153.54	153.54	1550.0
2018-11-06 08:00:00	IWM	ETF	153.4101	153.54	153.41	153.45	6187.0
2018-11-06 09:00:00	IWM	ETF	153.52	154.24	153.5	153.985	1353877.0
2018-11-06 10:00:00	IWM	ETF	153.97	154.59	153.77	154.5	1467531.0
2018-11-06 11:00:00	IWM	ETF	154.55	154.56	153.67	154.07	1319223.0
2018-11-06 12:00:00	IWM	ETF	154.1	155.01	153.95	154.71	1624730.0
2018-11-06 13:00:00	IWM	ETF	154.74	155.11	154.72	154.9	1275874.0
2018-11-06 14:00:00	IWM	ETF	154.9	154.96	153.98	154.18	1419205.0
2018-11-06 15:00:00	IWM	ETF	154.17	154.79	154.0	154.63	3370779.0
2018-11-06 16:00:00	IWM	ETF	154.64	155.16	154.62	154.78	1522099.0
2018-11-06 17:00:00	IWM	ETF	154.72	154.9	154.66	154.81	41875.0
2018-11-06 18:00:00	IWM	ETF	154.71	154.71	154.4	154.4	19518.0
2018-11-06 19:00:00	IWM	ETF	154.42	154.76	154.15	154.42	23520.0
2018-11-06 04:00:00	DIA	ETF	254.22	254.22	254.22	254.22	100.0
2018-11-06 05:00:00	DIA	ETF	254.09	254.44	254.08	254.44	300.0
2018-11-06 06:00:00	DIA	ETF	254.28	254.28	254.28	254.28	100.0

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

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