PREVIEW / etf_1hour / 2020-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-30.parquet
  size:    383 KB
  rows:    13,050

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
2020-04-30 04:00:00	SPY	ETF	294.4	295.42	294.11	294.38	131393.0
2020-04-30 05:00:00	SPY	ETF	294.51	295.07	294.26	294.9	73069.0
2020-04-30 06:00:00	SPY	ETF	295.11	295.3	293.08	293.53	266060.0
2020-04-30 07:00:00	SPY	ETF	293.58	293.8	292.24	292.33	1192431.0
2020-04-30 08:00:00	SPY	ETF	292.36	296.77	291.11	291.15	1592403.0
2020-04-30 09:00:00	SPY	ETF	291.14	291.73	289.58	291.235	15162914.0
2020-04-30 10:00:00	SPY	ETF	291.24	292.235	290.575	291.04	17338841.0
2020-04-30 11:00:00	SPY	ETF	291.04	291.91	289.55	289.6	12494231.0
2020-04-30 12:00:00	SPY	ETF	289.585	290.125	288.59	289.98	14429085.0
2020-04-30 13:00:00	SPY	ETF	289.96	293.3239	289.11	289.2195	8779396.0
2020-04-30 14:00:00	SPY	ETF	289.21	290.21	288.86	289.33	10292903.0
2020-04-30 15:00:00	SPY	ETF	289.33	291.18	289.115	290.39	24308543.0
2020-04-30 16:00:00	SPY	ETF	290.37	290.65	288.12	288.55	11768051.0
2020-04-30 17:00:00	SPY	ETF	288.63	290.48	287.35	287.45	914244.0
2020-04-30 18:00:00	SPY	ETF	287.42	287.44	285.61	287.0	1076488.0
2020-04-30 19:00:00	SPY	ETF	287.03	287.8	286.8	287.7	278807.0
2020-04-30 04:00:00	QQQ	ETF	221.47	221.88	221.21	221.45	32413.0
2020-04-30 05:00:00	QQQ	ETF	221.49	221.93	221.4	221.93	15520.0
2020-04-30 06:00:00	QQQ	ETF	221.99	222.15	220.72	220.98	35305.0
2020-04-30 07:00:00	QQQ	ETF	221.03	221.54	220.75	220.75	224527.0
2020-04-30 08:00:00	QQQ	ETF	221.1001	223.04	219.38	219.38	513310.0
2020-04-30 09:00:00	QQQ	ETF	219.42	220.04	218.12	219.545	5944056.0
2020-04-30 10:00:00	QQQ	ETF	219.55	219.94	218.31	218.86	5747360.0
2020-04-30 11:00:00	QQQ	ETF	218.89	219.7	218.17	218.18	3770751.0
2020-04-30 12:00:00	QQQ	ETF	218.18	218.4	217.35	218.29	4129844.0
2020-04-30 13:00:00	QQQ	ETF	218.285	218.5799	217.58	217.8	2911668.0
2020-04-30 14:00:00	QQQ	ETF	217.77	218.47	217.41	217.725	2726462.0
2020-04-30 15:00:00	QQQ	ETF	217.73	219.58	217.565	219.17	8956943.0
2020-04-30 16:00:00	QQQ	ETF	219.19	219.3512	216.1	216.42	3404500.0
2020-04-30 17:00:00	QQQ	ETF	216.38	216.53	215.91	215.96	145293.0
2020-04-30 18:00:00	QQQ	ETF	215.96	215.96	214.89	215.51	294830.0
2020-04-30 19:00:00	QQQ	ETF	215.52	215.78	215.23	215.7	156841.0
2020-04-30 04:00:00	IWM	ETF	135.32	135.85	135.19	135.38	9573.0
2020-04-30 05:00:00	IWM	ETF	135.16	135.58	135.16	135.39	16020.0
2020-04-30 06:00:00	IWM	ETF	135.54	135.62	133.0	133.64	79066.0
2020-04-30 07:00:00	IWM	ETF	133.79	134.08	132.6	132.92	255289.0
2020-04-30 08:00:00	IWM	ETF	133.3599	136.72	131.91	131.98	461212.0
2020-04-30 09:00:00	IWM	ETF	131.96	132.25	130.68	131.69	6605016.0
2020-04-30 10:00:00	IWM	ETF	131.69	132.81	131.36	132.375	4708165.0
2020-04-30 11:00:00	IWM	ETF	132.4	132.94	130.94	131.0289	3591982.0
2020-04-30 12:00:00	IWM	ETF	131.02	131.46	130.24	131.35	3520092.0
2020-04-30 13:00:00	IWM	ETF	131.35	131.51	130.44	130.52	2391913.0
2020-04-30 14:00:00	IWM	ETF	130.52	131.35	130.4	130.89	2113784.0
2020-04-30 15:00:00	IWM	ETF	130.89	131.27	130.14	130.32	8246092.0
2020-04-30 16:00:00	IWM	ETF	130.32	130.59	129.36	129.73	2831141.0
2020-04-30 17:00:00	IWM	ETF	129.73	130.31	129.11	129.13	133083.0
2020-04-30 18:00:00	IWM	ETF	129.3	130.31	127.95	128.51	204210.0
2020-04-30 19:00:00	IWM	ETF	128.62	128.88	128.37	128.88	30435.0
2020-04-30 04:00:00	DIA	ETF	247.14	247.19	247.04	247.19	2000.0
2020-04-30 05:00:00	DIA	ETF	247.13	247.23	246.99	247.23	1400.0

> showing 50 of 13,050 rows — these rows as CSV

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