PREVIEW / etf_1hour / 2018-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-30.parquet
  size:    317 KB
  rows:    10,473

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-30 04:00:00	SPY	ETF	273.72	273.8	273.53	273.69	5669.0
2018-11-30 05:00:00	SPY	ETF	273.54	273.68	273.35	273.35	11004.0
2018-11-30 06:00:00	SPY	ETF	273.38	273.4	273.08	273.2	92500.0
2018-11-30 07:00:00	SPY	ETF	273.22	273.43	273.04	273.3	147942.0
2018-11-30 08:00:00	SPY	ETF	273.98	274.22	273.08	274.02	993937.0
2018-11-30 09:00:00	SPY	ETF	274.02	274.259	273.45	274.18	5680602.0
2018-11-30 10:00:00	SPY	ETF	274.19	274.98	273.94	274.47	11418515.0
2018-11-30 11:00:00	SPY	ETF	274.46	274.69	273.73	274.525	8109777.0
2018-11-30 12:00:00	SPY	ETF	274.53	274.59	274.05	274.07	4681076.0
2018-11-30 13:00:00	SPY	ETF	274.08	275.33	273.85	275.19	8975869.0
2018-11-30 14:00:00	SPY	ETF	275.19	275.5	274.96	275.27	9961264.0
2018-11-30 15:00:00	SPY	ETF	275.265	276.28	275.195	275.76	26692090.0
2018-11-30 16:00:00	SPY	ETF	275.74	276.58	275.5	276.48	15759393.0
2018-11-30 17:00:00	SPY	ETF	276.45	276.55	275.65	275.65	3514602.0
2018-11-30 18:00:00	SPY	ETF	276.42	276.45	275.65	276.35	29449.0
2018-11-30 19:00:00	SPY	ETF	276.32	276.57	276.32	276.53	37062.0
2018-11-30 04:00:00	QQQ	ETF	167.99	168.0	167.97	167.98	4598.0
2018-11-30 05:00:00	QQQ	ETF	167.9	168.05	167.77	167.8	24963.0
2018-11-30 06:00:00	QQQ	ETF	167.77	167.78	167.6	167.63	26770.0
2018-11-30 07:00:00	QQQ	ETF	167.62	167.86	167.5	167.8	71006.0
2018-11-30 08:00:00	QQQ	ETF	167.62	168.6	167.56	168.49	679248.0
2018-11-30 09:00:00	QQQ	ETF	168.46	168.53	167.54	168.105	2810432.0
2018-11-30 10:00:00	QQQ	ETF	168.1	169.0	167.76	168.5	3367590.0
2018-11-30 11:00:00	QQQ	ETF	168.5	168.68	168.03	168.53	3460652.0
2018-11-30 12:00:00	QQQ	ETF	168.54	168.55	168.02	168.04	1877445.0
2018-11-30 13:00:00	QQQ	ETF	168.04	168.855	167.82	168.75	3540193.0
2018-11-30 14:00:00	QQQ	ETF	168.75	168.81	168.41	168.6	2852609.0
2018-11-30 15:00:00	QQQ	ETF	168.6	169.47	168.59	169.42	8921942.0
2018-11-30 16:00:00	QQQ	ETF	169.42	169.84	169.24	169.78	2570546.0
2018-11-30 17:00:00	QQQ	ETF	169.8	169.8	169.37	169.75	16212.0
2018-11-30 18:00:00	QQQ	ETF	169.67	169.8	169.37	169.74	20528.0
2018-11-30 19:00:00	QQQ	ETF	169.71	169.84	169.68	169.84	6175.0
2018-11-30 04:00:00	IWM	ETF	151.5	151.5	151.5	151.5	600.0
2018-11-30 05:00:00	IWM	ETF	151.41	151.41	151.41	151.41	100.0
2018-11-30 06:00:00	IWM	ETF	151.25	151.25	151.25	151.25	100.0
2018-11-30 07:00:00	IWM	ETF	151.19	151.34	151.09	151.34	5471.0
2018-11-30 08:00:00	IWM	ETF	151.15	151.64	151.11	151.57	55151.0
2018-11-30 09:00:00	IWM	ETF	151.45	152.07	151.08	151.995	1259130.0
2018-11-30 10:00:00	IWM	ETF	152.01	152.44	151.6	151.91	2018666.0
2018-11-30 11:00:00	IWM	ETF	151.91	152.19	151.44	152.0	1239434.0
2018-11-30 12:00:00	IWM	ETF	152.01	152.02	151.34	151.37	946939.0
2018-11-30 13:00:00	IWM	ETF	151.38	151.99	151.15	151.871	1522946.0
2018-11-30 14:00:00	IWM	ETF	151.89	152.06	151.68	152.01	1355332.0
2018-11-30 15:00:00	IWM	ETF	152.03	152.86	151.97	152.59	5165458.0
2018-11-30 16:00:00	IWM	ETF	152.63	152.85	149.2	152.74	1550553.0
2018-11-30 17:00:00	IWM	ETF	152.66	152.66	152.62	152.62	42900.0
2018-11-30 18:00:00	IWM	ETF	152.62	152.73	152.62	152.73	864.0
2018-11-30 19:00:00	IWM	ETF	152.73	152.82	152.73	152.82	1330.0
2018-11-30 04:00:00	DIA	ETF	253.47	253.47	253.47	253.47	100.0
2018-11-30 05:00:00	DIA	ETF	253.22	253.22	253.22	253.22	400.0

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

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