PREVIEW / etf_30min / 2020-11-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-13.parquet
  size:    573 KB
  rows:    20,977

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-11-13 04:00:00	SPY	ETF	355.1	355.66	354.99	355.53	32475.0
2020-11-13 04:30:00	SPY	ETF	355.69	356.37	355.69	356.32	34548.0
2020-11-13 05:00:00	SPY	ETF	356.28	356.8	356.14	356.25	107819.0
2020-11-13 05:30:00	SPY	ETF	356.15	356.56	356.06	356.32	65830.0
2020-11-13 06:00:00	SPY	ETF	356.44	356.45	355.53	355.78	20520.0
2020-11-13 06:30:00	SPY	ETF	355.75	355.97	355.38	355.8	190024.0
2020-11-13 07:00:00	SPY	ETF	355.87	355.9	355.44	355.67	123162.0
2020-11-13 07:30:00	SPY	ETF	355.7	355.95	355.36	355.39	206894.0
2020-11-13 08:00:00	SPY	ETF	355.46	355.88	353.39	355.72	149464.0
2020-11-13 08:30:00	SPY	ETF	355.73	355.92	355.6	355.71	366494.0
2020-11-13 09:00:00	SPY	ETF	355.71	355.71	355.2002	355.29	207196.0
2020-11-13 09:30:00	SPY	ETF	355.27	356.2399	355.22	356.03	4973727.0
2020-11-13 10:00:00	SPY	ETF	356.03	356.12	355.06	355.855	3747890.0
2020-11-13 10:30:00	SPY	ETF	355.85	355.88	354.71	355.19	3829779.0
2020-11-13 11:00:00	SPY	ETF	355.2	356.0	355.2	355.68	2955277.0
2020-11-13 11:30:00	SPY	ETF	355.7	356.39	355.37	356.27	3337889.0
2020-11-13 12:00:00	SPY	ETF	356.29	356.5	356.075	356.23	1437966.0
2020-11-13 12:30:00	SPY	ETF	356.24	356.74	356.16	356.7399	1684380.0
2020-11-13 13:00:00	SPY	ETF	356.74	357.13	356.59	356.86	2537376.0
2020-11-13 13:30:00	SPY	ETF	356.875	356.94	356.5	356.6	1523581.0
2020-11-13 14:00:00	SPY	ETF	356.6	357.64	356.42	357.3111	3700086.0
2020-11-13 14:30:00	SPY	ETF	357.32	357.81	357.03	357.66	2967353.0
2020-11-13 15:00:00	SPY	ETF	357.66	357.8	356.96	357.71	4573552.0
2020-11-13 15:30:00	SPY	ETF	357.7	358.9	357.59	358.05	12552836.0
2020-11-13 16:00:00	SPY	ETF	358.05	358.33	357.83	358.14	9511471.0
2020-11-13 16:30:00	SPY	ETF	358.12	358.32	358.0	358.13	326687.0
2020-11-13 17:00:00	SPY	ETF	358.1	358.35	358.09	358.28	153765.0
2020-11-13 17:30:00	SPY	ETF	358.3	358.34	358.1	358.33	26930.0
2020-11-13 18:00:00	SPY	ETF	358.3	358.32	358.1	358.25	14109.0
2020-11-13 18:30:00	SPY	ETF	358.23	358.29	358.13	358.26	15509.0
2020-11-13 19:00:00	SPY	ETF	358.29	358.29	358.25	358.27	5234.0
2020-11-13 19:30:00	SPY	ETF	358.2899	358.4	358.25	358.4	40149.0
2020-11-13 04:00:00	QQQ	ETF	290.16	290.33	290.01	290.17	14950.0
2020-11-13 04:30:00	QQQ	ETF	290.19	291.08	290.19	291.04	26275.0
2020-11-13 05:00:00	QQQ	ETF	290.96	291.04	290.61	290.61	7513.0
2020-11-13 05:30:00	QQQ	ETF	290.55	290.72	290.49	290.63	25118.0
2020-11-13 06:00:00	QQQ	ETF	290.61	290.66	290.26	290.41	14055.0
2020-11-13 06:30:00	QQQ	ETF	290.44	290.52	290.08	290.33	56539.0
2020-11-13 07:00:00	QQQ	ETF	290.29	290.662	290.07	290.54	74721.0
2020-11-13 07:30:00	QQQ	ETF	290.56	290.69	289.95	290.0	83146.0
2020-11-13 08:00:00	QQQ	ETF	290.6399	290.6499	289.48	290.34	78789.0
2020-11-13 08:30:00	QQQ	ETF	290.32	290.57	290.07	290.24	90615.0
2020-11-13 09:00:00	QQQ	ETF	290.24	290.3	290.0	290.06	136583.0
2020-11-13 09:30:00	QQQ	ETF	290.01	290.84	289.56	289.8664	2980484.0
2020-11-13 10:00:00	QQQ	ETF	289.82	289.96	288.6	289.521	2273800.0
2020-11-13 10:30:00	QQQ	ETF	289.55	289.55	287.8701	288.31	1732101.0
2020-11-13 11:00:00	QQQ	ETF	288.31	289.5	288.285	288.97	1513914.0
2020-11-13 11:30:00	QQQ	ETF	288.96	289.89	288.56	289.64	1359187.0
2020-11-13 12:00:00	QQQ	ETF	289.665	289.99	289.445	289.715	758574.0
2020-11-13 12:30:00	QQQ	ETF	289.74	290.265	289.5518	290.2433	801158.0

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

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