PREVIEW / etf_30min / 2020-04-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-30.parquet
  size:    584 KB
  rows:    21,513

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	294.66	294.11	294.4	69300.0
2020-04-30 04:30:00	SPY	ETF	294.58	295.42	294.38	294.38	62093.0
2020-04-30 05:00:00	SPY	ETF	294.51	294.74	294.26	294.71	13909.0
2020-04-30 05:30:00	SPY	ETF	294.7	295.07	294.57	294.9	59160.0
2020-04-30 06:00:00	SPY	ETF	295.11	295.3	294.4	294.49	32568.0
2020-04-30 06:30:00	SPY	ETF	294.26	294.32	293.08	293.53	233492.0
2020-04-30 07:00:00	SPY	ETF	293.58	293.78	292.91	292.97	513407.0
2020-04-30 07:30:00	SPY	ETF	292.98	293.8	292.24	292.33	679024.0
2020-04-30 08:00:00	SPY	ETF	292.36	296.77	292.21	292.64	526763.0
2020-04-30 08:30:00	SPY	ETF	292.67	293.29	291.11	291.15	1065640.0
2020-04-30 09:00:00	SPY	ETF	291.14	291.71	290.4	291.71	1128363.0
2020-04-30 09:30:00	SPY	ETF	291.71	291.73	289.58	291.235	14034551.0
2020-04-30 10:00:00	SPY	ETF	291.24	292.15	290.62	292.02	8713183.0
2020-04-30 10:30:00	SPY	ETF	292.01	292.235	290.575	291.04	8625658.0
2020-04-30 11:00:00	SPY	ETF	291.04	291.91	290.77	290.8	6812852.0
2020-04-30 11:30:00	SPY	ETF	290.792	291.32	289.55	289.6	5681379.0
2020-04-30 12:00:00	SPY	ETF	289.585	289.68	288.78	289.2	6624395.0
2020-04-30 12:30:00	SPY	ETF	289.18	290.125	288.59	289.98	7804690.0
2020-04-30 13:00:00	SPY	ETF	289.96	293.3239	289.33	289.7637	4768008.0
2020-04-30 13:30:00	SPY	ETF	289.75	289.96	289.11	289.2195	4011388.0
2020-04-30 14:00:00	SPY	ETF	289.21	289.95	288.86	289.7169	3565250.0
2020-04-30 14:30:00	SPY	ETF	289.71	290.21	288.95	289.33	6727653.0
2020-04-30 15:00:00	SPY	ETF	289.33	290.9	289.115	290.56	6432340.0
2020-04-30 15:30:00	SPY	ETF	290.55	291.18	289.58	290.39	17876203.0
2020-04-30 16:00:00	SPY	ETF	290.37	290.65	289.09	289.73	8345159.0
2020-04-30 16:30:00	SPY	ETF	289.77	290.6288	288.12	288.55	3422892.0
2020-04-30 17:00:00	SPY	ETF	288.63	289.0	287.55	287.72	295825.0
2020-04-30 17:30:00	SPY	ETF	287.62	290.48	287.35	287.45	618419.0
2020-04-30 18:00:00	SPY	ETF	287.42	287.44	285.61	286.5	905184.0
2020-04-30 18:30:00	SPY	ETF	286.55	287.0	286.1	287.0	171304.0
2020-04-30 19:00:00	SPY	ETF	287.03	287.31	286.8	287.13	99330.0
2020-04-30 19:30:00	SPY	ETF	287.22	287.8	287.0	287.7	179477.0
2020-04-30 04:00:00	QQQ	ETF	221.47	221.68	221.21	221.38	27048.0
2020-04-30 04:30:00	QQQ	ETF	221.62	221.88	221.45	221.45	5365.0
2020-04-30 05:00:00	QQQ	ETF	221.49	221.72	221.4	221.58	10500.0
2020-04-30 05:30:00	QQQ	ETF	221.85	221.93	221.72	221.93	5020.0
2020-04-30 06:00:00	QQQ	ETF	221.99	222.15	221.41	221.57	8299.0
2020-04-30 06:30:00	QQQ	ETF	221.31	221.37	220.72	220.98	27006.0
2020-04-30 07:00:00	QQQ	ETF	221.03	221.18	220.8	220.8	117743.0
2020-04-30 07:30:00	QQQ	ETF	220.89	221.54	220.75	220.75	106784.0
2020-04-30 08:00:00	QQQ	ETF	221.1001	223.04	220.26	220.69	208132.0
2020-04-30 08:30:00	QQQ	ETF	220.52	221.14	219.38	219.38	305178.0
2020-04-30 09:00:00	QQQ	ETF	219.42	220.03	219.0	220.03	400375.0
2020-04-30 09:30:00	QQQ	ETF	220.01	220.04	218.12	219.545	5543681.0
2020-04-30 10:00:00	QQQ	ETF	219.55	219.94	218.7802	219.69	3496089.0
2020-04-30 10:30:00	QQQ	ETF	219.695	219.835	218.31	218.86	2251271.0
2020-04-30 11:00:00	QQQ	ETF	218.89	219.7	218.87	218.93	1949233.0
2020-04-30 11:30:00	QQQ	ETF	218.92	219.22	218.17	218.18	1821518.0
2020-04-30 12:00:00	QQQ	ETF	218.18	218.2275	217.5	217.72	2212982.0
2020-04-30 12:30:00	QQQ	ETF	217.7167	218.4	217.35	218.29	1916862.0

> showing 50 of 21,513 rows — these rows as CSV

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