PREVIEW / etf_30min / 2020-05-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-05.parquet
  size:    561 KB
  rows:    20,462

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-05-05 04:00:00	SPY	ETF	286.17	286.82	285.68	286.51	63827.0
2020-05-05 04:30:00	SPY	ETF	286.52	286.52	283.72	283.78	149651.0
2020-05-05 05:00:00	SPY	ETF	283.7	285.04	283.61	284.65	49374.0
2020-05-05 05:30:00	SPY	ETF	284.39	285.45	284.39	285.17	27040.0
2020-05-05 06:00:00	SPY	ETF	285.39	285.97	285.03	285.2	32899.0
2020-05-05 06:30:00	SPY	ETF	285.2	285.82	285.1	285.7	47978.0
2020-05-05 07:00:00	SPY	ETF	285.79	286.25	285.51	285.91	236572.0
2020-05-05 07:30:00	SPY	ETF	285.89	286.1	285.54	285.9	277344.0
2020-05-05 08:00:00	SPY	ETF	285.91	286.79	284.13	286.68	287648.0
2020-05-05 08:30:00	SPY	ETF	286.68	286.75	286.26	286.46	215277.0
2020-05-05 09:00:00	SPY	ETF	286.46	286.94	286.23	286.67	282939.0
2020-05-05 09:30:00	SPY	ETF	286.64	288.16	286.26	288.1528	8557738.0
2020-05-05 10:00:00	SPY	ETF	288.16	288.47	287.37	287.51	6014170.0
2020-05-05 10:30:00	SPY	ETF	287.5	288.05	287.35	287.9664	4479089.0
2020-05-05 11:00:00	SPY	ETF	287.965	288.605	287.83	288.52	3937554.0
2020-05-05 11:30:00	SPY	ETF	288.52	288.96	288.5	288.855	3466545.0
2020-05-05 12:00:00	SPY	ETF	288.87	289.24	288.705	288.775	3545507.0
2020-05-05 12:30:00	SPY	ETF	288.79	288.95	288.3	288.4	3946615.0
2020-05-05 13:00:00	SPY	ETF	288.41	288.61	288.0	288.5	4306087.0
2020-05-05 13:30:00	SPY	ETF	288.51	288.95	288.48	288.74	2746424.0
2020-05-05 14:00:00	SPY	ETF	288.74	289.16	288.54	289.03	2542830.0
2020-05-05 14:30:00	SPY	ETF	289.04	289.25	288.46	289.23	3374192.0
2020-05-05 15:00:00	SPY	ETF	289.23	289.23	286.91	287.17	8090176.0
2020-05-05 15:30:00	SPY	ETF	287.16	287.41	285.75	286.22	17225731.0
2020-05-05 16:00:00	SPY	ETF	286.14	286.37	285.86	286.0	3697175.0
2020-05-05 16:30:00	SPY	ETF	286.0	286.3	285.58	286.3	755132.0
2020-05-05 17:00:00	SPY	ETF	286.3	286.45	286.0	286.35	247784.0
2020-05-05 17:30:00	SPY	ETF	286.4	286.4	286.1	286.11	44716.0
2020-05-05 18:00:00	SPY	ETF	286.11	287.0	285.79	286.75	157831.0
2020-05-05 18:30:00	SPY	ETF	286.72	287.19	286.38	287.15	59846.0
2020-05-05 19:00:00	SPY	ETF	287.12	287.12	286.85	286.94	49854.0
2020-05-05 19:30:00	SPY	ETF	286.99	287.22	286.82	287.02	101075.0
2020-05-05 04:00:00	QQQ	ETF	217.16	217.6	216.89	217.45	50628.0
2020-05-05 04:30:00	QQQ	ETF	217.22	217.22	215.44	215.56	39166.0
2020-05-05 05:00:00	QQQ	ETF	215.4	216.32	215.38	216.19	18883.0
2020-05-05 05:30:00	QQQ	ETF	215.98	216.7	215.96	216.68	17531.0
2020-05-05 06:00:00	QQQ	ETF	216.72	217.12	216.5	216.53	25416.0
2020-05-05 06:30:00	QQQ	ETF	216.58	217.01	216.58	216.77	25932.0
2020-05-05 07:00:00	QQQ	ETF	217.03	217.49	216.82	217.25	81429.0
2020-05-05 07:30:00	QQQ	ETF	217.22	217.45	217.0	217.35	77769.0
2020-05-05 08:00:00	QQQ	ETF	217.2001	217.84	216.14	217.7	167920.0
2020-05-05 08:30:00	QQQ	ETF	217.7	217.71	217.38	217.53	92732.0
2020-05-05 09:00:00	QQQ	ETF	217.51	217.75	217.28	217.38	157744.0
2020-05-05 09:30:00	QQQ	ETF	217.4	218.64	217.115	218.63	5195114.0
2020-05-05 10:00:00	QQQ	ETF	218.63	218.98	218.145	218.32	2855243.0
2020-05-05 10:30:00	QQQ	ETF	218.3486	218.84	218.22	218.78	1858663.0
2020-05-05 11:00:00	QQQ	ETF	218.77	219.1494	218.5	218.9701	1413237.0
2020-05-05 11:30:00	QQQ	ETF	218.99	219.35	218.84	219.31	1606111.0
2020-05-05 12:00:00	QQQ	ETF	219.31	219.625	219.0599	219.1	2116691.0
2020-05-05 12:30:00	QQQ	ETF	219.0935	219.25	218.82	219.05	1599151.0

> showing 50 of 20,462 rows — these rows as CSV

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