PREVIEW / etf_30min / 2020-02-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-26.parquet
  size:    602 KB
  rows:    21,500

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-02-26 04:00:00	SPY	ETF	311.76	311.76	309.08	311.25	310872.0
2020-02-26 04:30:00	SPY	ETF	311.27	312.15	310.84	311.32	112667.0
2020-02-26 05:00:00	SPY	ETF	311.55	313.16	311.38	313.1	88857.0
2020-02-26 05:30:00	SPY	ETF	313.03	313.16	311.75	311.78	68527.0
2020-02-26 06:00:00	SPY	ETF	311.82	313.8	311.82	313.5	111641.0
2020-02-26 06:30:00	SPY	ETF	313.58	314.36	313.33	313.4	144293.0
2020-02-26 07:00:00	SPY	ETF	313.38	314.17	312.66	312.95	506467.0
2020-02-26 07:30:00	SPY	ETF	313.14	313.97	312.16	313.72	625625.0
2020-02-26 08:00:00	SPY	ETF	314.1033	315.0	311.54	314.33	988428.0
2020-02-26 08:30:00	SPY	ETF	314.3	315.9	313.72	313.99	965263.0
2020-02-26 09:00:00	SPY	ETF	313.98	314.68	313.88	314.19	815128.0
2020-02-26 09:30:00	SPY	ETF	314.18	317.45	313.84	315.5248	21152338.0
2020-02-26 10:00:00	SPY	ETF	315.51	317.11	314.65	316.34	11713482.0
2020-02-26 10:30:00	SPY	ETF	316.33	318.11	316.33	317.17	11464696.0
2020-02-26 11:00:00	SPY	ETF	317.16	317.74	316.0709	317.52	7180176.0
2020-02-26 11:30:00	SPY	ETF	317.52	317.53	315.12	315.41	7151838.0
2020-02-26 12:00:00	SPY	ETF	315.42	315.61	312.69	314.1	16395461.0
2020-02-26 12:30:00	SPY	ETF	314.09	315.2	313.78	314.34	8273831.0
2020-02-26 13:00:00	SPY	ETF	314.33	314.78	313.47	314.08	5825937.0
2020-02-26 13:30:00	SPY	ETF	314.07	314.18	310.7	311.1	23557535.0
2020-02-26 14:00:00	SPY	ETF	311.09	313.13	310.74	312.18	12654780.0
2020-02-26 14:30:00	SPY	ETF	312.21	313.06	311.28	311.41	10852455.0
2020-02-26 15:00:00	SPY	ETF	311.41	313.46	311.41	312.12	15019434.0
2020-02-26 15:30:00	SPY	ETF	312.115	312.6802	311.41	311.55	18282998.0
2020-02-26 16:00:00	SPY	ETF	311.56	311.72	310.51	310.66	12291444.0
2020-02-26 16:30:00	SPY	ETF	310.67	311.5026	309.82	309.99	2043790.0
2020-02-26 17:00:00	SPY	ETF	309.95	310.24	309.95	310.11	391145.0
2020-02-26 17:30:00	SPY	ETF	310.11	310.4	309.92	310.23	246879.0
2020-02-26 18:00:00	SPY	ETF	310.15	311.15	309.6	311.0	508067.0
2020-02-26 18:30:00	SPY	ETF	310.99	311.64	309.3	310.28	590181.0
2020-02-26 19:00:00	SPY	ETF	310.28	310.5	307.88	309.81	511577.0
2020-02-26 19:30:00	SPY	ETF	309.78	310.7	308.9	309.32	301615.0
2020-02-26 04:00:00	QQQ	ETF	214.58	214.58	212.39	214.05	179981.0
2020-02-26 04:30:00	QQQ	ETF	214.12	214.82	213.81	214.13	71623.0
2020-02-26 05:00:00	QQQ	ETF	214.25	215.64	214.25	215.55	120727.0
2020-02-26 05:30:00	QQQ	ETF	215.69	215.69	214.53	214.66	73812.0
2020-02-26 06:00:00	QQQ	ETF	214.61	216.41	214.6	216.28	166026.0
2020-02-26 06:30:00	QQQ	ETF	216.21	216.97	215.97	216.0	121836.0
2020-02-26 07:00:00	QQQ	ETF	215.95	216.64	215.28	215.57	343658.0
2020-02-26 07:30:00	QQQ	ETF	215.64	216.32	214.94	216.05	389506.0
2020-02-26 08:00:00	QQQ	ETF	215.97	217.3	214.5	216.68	587534.0
2020-02-26 08:30:00	QQQ	ETF	216.69	217.61	216.31	216.6298	427253.0
2020-02-26 09:00:00	QQQ	ETF	216.62	217.28	216.36	216.66	401466.0
2020-02-26 09:30:00	QQQ	ETF	216.67	219.74	216.45	218.265	10843097.0
2020-02-26 10:00:00	QQQ	ETF	218.24	219.68	217.55	219.15	6526620.0
2020-02-26 10:30:00	QQQ	ETF	219.16	220.28	219.11	219.57	5120133.0
2020-02-26 11:00:00	QQQ	ETF	219.57	220.01	218.6987	219.85	3103047.0
2020-02-26 11:30:00	QQQ	ETF	219.85	219.9	218.14	218.38	3303738.0
2020-02-26 12:00:00	QQQ	ETF	218.38	218.55	216.12	217.47	5283295.0
2020-02-26 12:30:00	QQQ	ETF	217.48	218.31	217.28	217.67	3049813.0

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

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