PREVIEW / etf_1hour / 2018-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-20.parquet
  size:    354 KB
  rows:    11,553

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-12-20 04:00:00	SPY	ETF	250.0	250.6	249.48	250.58	54278.0
2018-12-20 05:00:00	SPY	ETF	250.64	251.01	250.19	250.59	72336.0
2018-12-20 06:00:00	SPY	ETF	250.68	251.67	250.68	251.6	74932.0
2018-12-20 07:00:00	SPY	ETF	251.57	252.26	251.15	251.61	423334.0
2018-12-20 08:00:00	SPY	ETF	251.6	251.96	248.42	250.25	1251712.0
2018-12-20 09:00:00	SPY	ETF	250.24	250.83	248.89	250.41	23137919.0
2018-12-20 10:00:00	SPY	ETF	250.41	251.62	249.88	250.59	26808416.0
2018-12-20 11:00:00	SPY	ETF	250.58	250.72	246.7875	247.66	29744696.0
2018-12-20 12:00:00	SPY	ETF	247.66	249.23	246.91	248.3064	24921660.0
2018-12-20 13:00:00	SPY	ETF	248.31	248.37	246.63	246.78	18116728.0
2018-12-20 14:00:00	SPY	ETF	246.785	249.47	244.65	247.92	43736734.0
2018-12-20 15:00:00	SPY	ETF	247.92	249.1	246.13	247.24	55554828.0
2018-12-20 16:00:00	SPY	ETF	247.22	249.19	247.07	249.14	19691077.0
2018-12-20 17:00:00	SPY	ETF	249.09	249.2	247.17	248.85	2659949.0
2018-12-20 18:00:00	SPY	ETF	248.92	249.49	248.65	248.65	3302863.0
2018-12-20 19:00:00	SPY	ETF	248.65	248.65	247.17	248.54	323017.0
2018-12-20 20:00:00	SPY	ETF	247.17	247.17	247.1	247.1	270.0
2018-12-20 04:00:00	QQQ	ETF	154.17	154.59	153.8	154.54	21550.0
2018-12-20 05:00:00	QQQ	ETF	154.59	154.84	154.29	154.64	77491.0
2018-12-20 06:00:00	QQQ	ETF	154.65	155.34	154.65	155.28	58469.0
2018-12-20 07:00:00	QQQ	ETF	155.26	155.58	155.01	155.43	99918.0
2018-12-20 08:00:00	QQQ	ETF	155.5	155.5599	153.49	154.1	438786.0
2018-12-20 09:00:00	QQQ	ETF	154.1	155.3	153.79	155.13	10168269.0
2018-12-20 10:00:00	QQQ	ETF	155.14	155.87	154.12	154.49	10329974.0
2018-12-20 11:00:00	QQQ	ETF	154.48	154.53	151.26	152.2698	16920409.0
2018-12-20 12:00:00	QQQ	ETF	152.27	153.315	151.54	152.88	10131164.0
2018-12-20 13:00:00	QQQ	ETF	152.88	152.94	151.63	151.7899	6899208.0
2018-12-20 14:00:00	QQQ	ETF	151.8	153.75	150.39	152.885	14326547.0
2018-12-20 15:00:00	QQQ	ETF	152.88	153.66	151.74	152.47	15904529.0
2018-12-20 16:00:00	QQQ	ETF	152.43	154.03	152.24	153.8	3074998.0
2018-12-20 17:00:00	QQQ	ETF	153.75	153.92	152.29	153.68	133200.0
2018-12-20 18:00:00	QQQ	ETF	153.67	154.05	153.5	153.53	135932.0
2018-12-20 19:00:00	QQQ	ETF	153.51	153.65	153.18	153.41	76899.0
2018-12-20 04:00:00	IWM	ETF	133.45	133.98	133.45	133.9	6151.0
2018-12-20 05:00:00	IWM	ETF	134.18	134.24	133.88	134.02	42100.0
2018-12-20 06:00:00	IWM	ETF	134.19	134.86	134.17	134.86	49511.0
2018-12-20 07:00:00	IWM	ETF	134.86	135.1	134.63	134.84	59831.0
2018-12-20 08:00:00	IWM	ETF	134.83	134.98	132.86	134.09	54388.0
2018-12-20 09:00:00	IWM	ETF	133.9	134.31	133.01	133.87	5276334.0
2018-12-20 10:00:00	IWM	ETF	133.85	134.41	132.98	133.2	5453940.0
2018-12-20 11:00:00	IWM	ETF	133.18	133.485	131.19	131.64	7358379.0
2018-12-20 12:00:00	IWM	ETF	131.66	132.54	131.44	132.12	5488723.0
2018-12-20 13:00:00	IWM	ETF	132.12	132.16	131.28	131.2901	4545212.0
2018-12-20 14:00:00	IWM	ETF	131.3	132.6	130.23	131.85	9681600.0
2018-12-20 15:00:00	IWM	ETF	131.83	132.72	131.28	131.79	10099517.0
2018-12-20 16:00:00	IWM	ETF	131.79	132.82	131.63	132.8	1526654.0
2018-12-20 17:00:00	IWM	ETF	132.75	132.86	131.79	131.79	1353520.0
2018-12-20 18:00:00	IWM	ETF	132.87	132.99	131.79	132.5	6588.0
2018-12-20 19:00:00	IWM	ETF	132.41	132.44	131.79	132.3	65030.0
2018-12-20 04:00:00	DIA	ETF	232.5	233.31	232.46	233.31	22020.0

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

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