PREVIEW / etf_1hour / 2018-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-11.parquet
  size:    348 KB
  rows:    11,366

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-10-11 04:00:00	SPY	ETF	275.29	275.36	274.45	274.65	240199.0
2018-10-11 05:00:00	SPY	ETF	274.57	275.22	273.82	275.0	367141.0
2018-10-11 06:00:00	SPY	ETF	274.93	275.39	274.5	275.08	248205.0
2018-10-11 07:00:00	SPY	ETF	275.08	276.06	274.72	275.77	1563258.0
2018-10-11 08:00:00	SPY	ETF	275.0	277.97	274.01	277.05	3971270.0
2018-10-11 09:00:00	SPY	ETF	277.08	278.9	276.21	278.7762	26707362.0
2018-10-11 10:00:00	SPY	ETF	278.77	278.79	275.7	275.79	30446213.0
2018-10-11 11:00:00	SPY	ETF	275.81	276.88	273.91	276.12	45839025.0
2018-10-11 12:00:00	SPY	ETF	276.1	277.82	275.81	276.38	17823679.0
2018-10-11 13:00:00	SPY	ETF	276.38	276.9	274.9	275.99	14167522.0
2018-10-11 14:00:00	SPY	ETF	275.97	276.14	270.36	272.49	44482173.0
2018-10-11 15:00:00	SPY	ETF	272.49	275.7	272.0	272.25	65031683.0
2018-10-11 16:00:00	SPY	ETF	272.26	274.54	271.8	273.83	18969183.0
2018-10-11 17:00:00	SPY	ETF	273.89	274.0499	272.17	273.93	348743.0
2018-10-11 18:00:00	SPY	ETF	273.9	277.08	273.65	274.79	1538642.0
2018-10-11 19:00:00	SPY	ETF	274.8	275.38	272.17	274.8	310723.0
2018-10-11 04:00:00	QQQ	ETF	169.75	170.1	169.28	169.41	85839.0
2018-10-11 05:00:00	QQQ	ETF	169.35	169.97	168.87	169.55	109549.0
2018-10-11 06:00:00	QQQ	ETF	169.63	169.89	169.18	169.64	147789.0
2018-10-11 07:00:00	QQQ	ETF	169.67	170.06	168.91	169.88	1113164.0
2018-10-11 08:00:00	QQQ	ETF	169.55	171.3	168.55	170.71	3561464.0
2018-10-11 09:00:00	QQQ	ETF	170.78	173.4	170.07	173.33	21093141.0
2018-10-11 10:00:00	QQQ	ETF	173.33	173.33	170.64	170.78	18542592.0
2018-10-11 11:00:00	QQQ	ETF	170.77	172.31	169.47	171.42	18580738.0
2018-10-11 12:00:00	QQQ	ETF	171.4199	172.9	171.27	171.81	7622577.0
2018-10-11 13:00:00	QQQ	ETF	171.8	172.45	170.84	171.59	8184503.0
2018-10-11 14:00:00	QQQ	ETF	171.59	171.785	167.81	169.19	18886563.0
2018-10-11 15:00:00	QQQ	ETF	169.19	171.81	168.84	169.63	25071354.0
2018-10-11 16:00:00	QQQ	ETF	169.62	171.38	169.19	171.05	6439406.0
2018-10-11 17:00:00	QQQ	ETF	171.1	171.1	170.75	170.84	224312.0
2018-10-11 18:00:00	QQQ	ETF	170.95	171.61	169.6	171.58	684772.0
2018-10-11 19:00:00	QQQ	ETF	171.6	172.08	169.6	171.72	186964.0
2018-10-11 04:00:00	IWM	ETF	155.05	155.05	154.37	154.45	16947.0
2018-10-11 05:00:00	IWM	ETF	154.16	154.68	153.96	154.47	12566.0
2018-10-11 06:00:00	IWM	ETF	154.67	154.75	154.35	154.64	9730.0
2018-10-11 07:00:00	IWM	ETF	154.69	155.17	154.49	154.93	102308.0
2018-10-11 08:00:00	IWM	ETF	154.74	155.8	154.27	155.61	232488.0
2018-10-11 09:00:00	IWM	ETF	155.61	157.315	155.13	157.21	8530002.0
2018-10-11 10:00:00	IWM	ETF	157.21	157.21	155.84	155.85	7395150.0
2018-10-11 11:00:00	IWM	ETF	155.85	156.46	155.06	155.9875	9423178.0
2018-10-11 12:00:00	IWM	ETF	155.99	157.06	155.81	156.47	4478534.0
2018-10-11 13:00:00	IWM	ETF	156.46	156.63	155.6	155.85	3231540.0
2018-10-11 14:00:00	IWM	ETF	155.84	155.88	153.59	154.16	8229360.0
2018-10-11 15:00:00	IWM	ETF	154.14	155.37	153.51	153.58	14658198.0
2018-10-11 16:00:00	IWM	ETF	153.54	156.5403	153.24	154.37	4398040.0
2018-10-11 17:00:00	IWM	ETF	154.3	154.4	154.15	154.31	13156.0
2018-10-11 18:00:00	IWM	ETF	154.52	154.9	153.57	154.9	12069.0
2018-10-11 19:00:00	IWM	ETF	154.9	155.11	153.57	154.89	305055.0
2018-10-11 04:00:00	DIA	ETF	252.86	252.86	252.34	252.34	2704.0
2018-10-11 05:00:00	DIA	ETF	252.08	252.8	251.73	252.8	4135.0

> showing 50 of 11,366 rows — these rows as CSV

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