PREVIEW / etf_30min / 2021-03-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-29.parquet
  size:    611 KB
  rows:    23,423

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
2021-03-29 04:00:00	SPY	ETF	394.03	394.03	393.19	393.62	72292.0
2021-03-29 04:30:00	SPY	ETF	393.7	393.8	393.4	393.68	12299.0
2021-03-29 05:00:00	SPY	ETF	393.61	393.98	393.61	393.88	22870.0
2021-03-29 05:30:00	SPY	ETF	393.83	394.49	393.83	394.48	13659.0
2021-03-29 06:00:00	SPY	ETF	394.46	394.73	394.34	394.73	31060.0
2021-03-29 06:30:00	SPY	ETF	394.6	394.77	394.5	394.5	92452.0
2021-03-29 07:00:00	SPY	ETF	394.49	395.03	394.49	394.89	103520.0
2021-03-29 07:30:00	SPY	ETF	394.88	394.94	394.32	394.39	154872.0
2021-03-29 08:00:00	SPY	ETF	394.74	395.0096	392.98	394.22	174923.0
2021-03-29 08:30:00	SPY	ETF	394.21	394.26	393.86	394.04	195618.0
2021-03-29 09:00:00	SPY	ETF	394.05	399.9398	393.8	394.39	473164.0
2021-03-29 09:30:00	SPY	ETF	394.4	395.71	394.06	394.11	8034258.0
2021-03-29 10:00:00	SPY	ETF	394.12	394.39	393.11	393.11	7351264.0
2021-03-29 10:30:00	SPY	ETF	393.1	394.16	392.9885	393.21	5058528.0
2021-03-29 11:00:00	SPY	ETF	393.21	393.9999	392.81	393.98	4997334.0
2021-03-29 11:30:00	SPY	ETF	393.99	394.87	393.77	394.66	4172980.0
2021-03-29 12:00:00	SPY	ETF	394.65	394.785	393.57	394.41	3750727.0
2021-03-29 12:30:00	SPY	ETF	394.415	395.87	394.23	395.82	3612161.0
2021-03-29 13:00:00	SPY	ETF	395.81	396.52	395.53	395.67	5143031.0
2021-03-29 13:30:00	SPY	ETF	395.66	396.64	395.5	395.62	3068740.0
2021-03-29 14:00:00	SPY	ETF	395.62	395.88	395.15	395.58	4319393.0
2021-03-29 14:30:00	SPY	ETF	395.57	396.01	394.9	395.46	4161431.0
2021-03-29 15:00:00	SPY	ETF	395.47	396.75	395.47	396.62	4710449.0
2021-03-29 15:30:00	SPY	ETF	396.61	396.67	395.12	395.77	13208394.0
2021-03-29 16:00:00	SPY	ETF	395.76	396.1	395.58	396.05	11691754.0
2021-03-29 16:30:00	SPY	ETF	396.05	396.05	395.79	395.88	234128.0
2021-03-29 17:00:00	SPY	ETF	395.88	396.25	395.69	396.25	177901.0
2021-03-29 17:30:00	SPY	ETF	396.1	396.15	396.01	396.1	61468.0
2021-03-29 18:00:00	SPY	ETF	396.03	396.43	395.78	396.32	91372.0
2021-03-29 18:30:00	SPY	ETF	396.33	396.33	396.11	396.11	17679.0
2021-03-29 19:00:00	SPY	ETF	396.14	396.16	395.85	396.02	17040.0
2021-03-29 19:30:00	SPY	ETF	396.01	396.28	395.92	396.19	20358.0
2021-03-29 04:00:00	QQQ	ETF	314.26	314.58	313.41	314.0	83309.0
2021-03-29 04:30:00	QQQ	ETF	313.97	314.16	313.81	314.16	161706.0
2021-03-29 05:00:00	QQQ	ETF	314.12	314.58	314.04	314.4	120585.0
2021-03-29 05:30:00	QQQ	ETF	314.35	315.45	314.33	315.35	22242.0
2021-03-29 06:00:00	QQQ	ETF	315.33	315.52	315.06	315.4	139883.0
2021-03-29 06:30:00	QQQ	ETF	315.37	315.83	315.35	315.58	16173.0
2021-03-29 07:00:00	QQQ	ETF	315.61	316.22	315.61	315.9	97438.0
2021-03-29 07:30:00	QQQ	ETF	315.95	316.22	315.66	315.78	154442.0
2021-03-29 08:00:00	QQQ	ETF	315.71	316.1496	312.36	315.7	120390.0
2021-03-29 08:30:00	QQQ	ETF	315.69	315.83	314.78	314.87	135982.0
2021-03-29 09:00:00	QQQ	ETF	314.9	315.53	314.3495	315.51	407937.0
2021-03-29 09:30:00	QQQ	ETF	315.5	316.38	313.35	313.38	6913898.0
2021-03-29 10:00:00	QQQ	ETF	313.39	313.9	312.47	312.91	6126665.0
2021-03-29 10:30:00	QQQ	ETF	312.91	314.66	312.76	313.65	3115156.0
2021-03-29 11:00:00	QQQ	ETF	313.68	314.09	312.82	314.01	3329781.0
2021-03-29 11:30:00	QQQ	ETF	314.04	314.94	313.61	314.47	2511246.0
2021-03-29 12:00:00	QQQ	ETF	314.49	314.65	313.4	314.15	1897246.0
2021-03-29 12:30:00	QQQ	ETF	314.15	316.22	313.95	316.18	2325753.0

> showing 50 of 23,423 rows — these rows as CSV

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