PREVIEW / etf_30min / 2021-03-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-12.parquet
  size:    626 KB
  rows:    23,927

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-12 04:00:00	SPY	ETF	394.5	394.5	390.92	391.12	29399.0
2021-03-12 04:30:00	SPY	ETF	391.19	391.36	391.02	391.25	11899.0
2021-03-12 05:00:00	SPY	ETF	391.23	391.25	390.88	390.95	21927.0
2021-03-12 05:30:00	SPY	ETF	391.0	391.7	391.0	391.36	39545.0
2021-03-12 06:00:00	SPY	ETF	391.3	391.53	390.99	391.17	19884.0
2021-03-12 06:30:00	SPY	ETF	391.3	391.72	391.24	391.3	26193.0
2021-03-12 07:00:00	SPY	ETF	391.35	392.2	391.29	391.78	161345.0
2021-03-12 07:30:00	SPY	ETF	391.75	392.6	391.7	392.54	119857.0
2021-03-12 08:00:00	SPY	ETF	392.54	394.05	391.2296	392.41	199828.0
2021-03-12 08:30:00	SPY	ETF	392.44	392.66	391.91	391.99	159273.0
2021-03-12 09:00:00	SPY	ETF	391.92	392.1196	391.54	392.1	334169.0
2021-03-12 09:30:00	SPY	ETF	392.08	392.91	391.28	392.86	8604047.0
2021-03-12 10:00:00	SPY	ETF	392.85	393.0901	391.28	391.71	5750423.0
2021-03-12 10:30:00	SPY	ETF	391.7	392.59	391.445	391.87	3867856.0
2021-03-12 11:00:00	SPY	ETF	391.84	392.229	391.2	392.213	2871615.0
2021-03-12 11:30:00	SPY	ETF	392.21	392.72	391.86	392.445	2037463.0
2021-03-12 12:00:00	SPY	ETF	392.45	393.0	392.07	393.0	1849900.0
2021-03-12 12:30:00	SPY	ETF	393.0	393.27	392.39	392.55	1854510.0
2021-03-12 13:00:00	SPY	ETF	392.54	393.1	392.2599	393.05	1512186.0
2021-03-12 13:30:00	SPY	ETF	393.045	393.18	392.61	392.7499	1440699.0
2021-03-12 14:00:00	SPY	ETF	392.75	393.15	392.63	393.0	2220766.0
2021-03-12 14:30:00	SPY	ETF	393.02	393.5001	392.81	393.371	2140889.0
2021-03-12 15:00:00	SPY	ETF	393.39	393.5701	392.81	393.43	2501750.0
2021-03-12 15:30:00	SPY	ETF	393.43	394.21	393.42	394.09	6272232.0
2021-03-12 16:00:00	SPY	ETF	394.09	394.54	394.0	394.16	4903679.0
2021-03-12 16:30:00	SPY	ETF	394.16	394.16	393.93	394.08	202898.0
2021-03-12 17:00:00	SPY	ETF	394.04	394.18	393.68	394.12	49554.0
2021-03-12 17:30:00	SPY	ETF	394.07	394.1	394.04	394.05	15079.0
2021-03-12 18:00:00	SPY	ETF	394.06	394.1	393.96	394.0	4076.0
2021-03-12 18:30:00	SPY	ETF	394.0	394.19	394.0	394.14	6616.0
2021-03-12 19:00:00	SPY	ETF	394.18	394.18	394.08	394.1	9047.0
2021-03-12 19:30:00	SPY	ETF	394.1	394.1	393.99	394.05	16066.0
2021-03-12 04:00:00	QQQ	ETF	315.9	316.04	312.55	312.91	115013.0
2021-03-12 04:30:00	QQQ	ETF	312.85	313.04	312.32	312.51	46566.0
2021-03-12 05:00:00	QQQ	ETF	312.51	312.51	311.86	312.16	65093.0
2021-03-12 05:30:00	QQQ	ETF	312.28	313.27	312.15	312.89	85532.0
2021-03-12 06:00:00	QQQ	ETF	312.86	313.14	312.42	312.59	40183.0
2021-03-12 06:30:00	QQQ	ETF	312.9	313.45	312.6	312.74	76473.0
2021-03-12 07:00:00	QQQ	ETF	312.86	314.1	312.86	313.68	347660.0
2021-03-12 07:30:00	QQQ	ETF	313.6	314.53	313.45	314.4	364632.0
2021-03-12 08:00:00	QQQ	ETF	314.4	318.51	312.6696	314.1	462057.0
2021-03-12 08:30:00	QQQ	ETF	314.05	315.29	313.15	313.25	639654.0
2021-03-12 09:00:00	QQQ	ETF	313.26	313.92	312.67	313.85	529263.0
2021-03-12 09:30:00	QQQ	ETF	313.85	314.46	312.09	314.34	7219565.0
2021-03-12 10:00:00	QQQ	ETF	314.32	314.71	311.53	312.28	5770842.0
2021-03-12 10:30:00	QQQ	ETF	312.27	313.24	311.44	311.99	4314698.0
2021-03-12 11:00:00	QQQ	ETF	311.97	313.09	311.391	313.02	3037898.0
2021-03-12 11:30:00	QQQ	ETF	313.03	314.05	312.55	313.6	2902584.0
2021-03-12 12:00:00	QQQ	ETF	313.6218	314.72	313.2	314.66	2404997.0
2021-03-12 12:30:00	QQQ	ETF	314.667	315.21	313.665	313.93	2711250.0

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

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