PREVIEW / etf_30min / 2021-03-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-22.parquet
  size:    615 KB
  rows:    23,512

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-22 04:00:00	SPY	ETF	389.75	390.4	388.34	389.35	56502.0
2021-03-22 04:30:00	SPY	ETF	389.42	389.61	389.17	389.28	15286.0
2021-03-22 05:00:00	SPY	ETF	389.4	389.47	388.9	389.25	7349.0
2021-03-22 05:30:00	SPY	ETF	389.47	389.57	389.26	389.37	59680.0
2021-03-22 06:00:00	SPY	ETF	389.48	389.83	389.48	389.83	3205.0
2021-03-22 06:30:00	SPY	ETF	389.82	389.86	389.71	389.85	9643.0
2021-03-22 07:00:00	SPY	ETF	389.76	390.66	389.76	390.57	165856.0
2021-03-22 07:30:00	SPY	ETF	390.6	390.72	390.4	390.53	62907.0
2021-03-22 08:00:00	SPY	ETF	389.96	390.7	388.48	390.31	77058.0
2021-03-22 08:30:00	SPY	ETF	390.28	390.39	390.01	390.21	97020.0
2021-03-22 09:00:00	SPY	ETF	390.18	390.46	390.03	390.06	172388.0
2021-03-22 09:30:00	SPY	ETF	390.03	391.49	389.97	391.3	7426946.0
2021-03-22 10:00:00	SPY	ETF	391.3	391.71	391.02	391.44	4589257.0
2021-03-22 10:30:00	SPY	ETF	391.45	392.44	391.3055	392.055	3439332.0
2021-03-22 11:00:00	SPY	ETF	392.055	392.28	391.86	392.13	1983119.0
2021-03-22 11:30:00	SPY	ETF	392.1299	392.61	392.12	392.37	2251740.0
2021-03-22 12:00:00	SPY	ETF	392.37	392.94	392.37	392.93	1707650.0
2021-03-22 12:30:00	SPY	ETF	392.93	393.23	392.73	393.145	2081601.0
2021-03-22 13:00:00	SPY	ETF	393.15	393.2	392.71	393.015	1738745.0
2021-03-22 13:30:00	SPY	ETF	393.007	393.33	393.007	393.31	1563009.0
2021-03-22 14:00:00	SPY	ETF	393.32	393.56	393.22	393.48	2619209.0
2021-03-22 14:30:00	SPY	ETF	393.49	393.97	393.485	393.76	2597065.0
2021-03-22 15:00:00	SPY	ETF	393.76	394.07	393.06	393.0982	3785657.0
2021-03-22 15:30:00	SPY	ETF	393.09	393.25	392.39	392.54	8420766.0
2021-03-22 16:00:00	SPY	ETF	392.5298	392.9	392.52	392.74	4790378.0
2021-03-22 16:30:00	SPY	ETF	392.74	392.96	392.59	392.85	1717589.0
2021-03-22 17:00:00	SPY	ETF	392.82	392.86	392.6	392.8	26436.0
2021-03-22 17:30:00	SPY	ETF	392.77	392.8	392.61	392.76	19973.0
2021-03-22 18:00:00	SPY	ETF	392.78	393.07	392.59	392.97	58294.0
2021-03-22 18:30:00	SPY	ETF	392.59	393.0	392.59	392.83	31355.0
2021-03-22 19:00:00	SPY	ETF	392.77	393.03	392.77	392.91	10300.0
2021-03-22 19:30:00	SPY	ETF	392.91	393.25	392.91	393.24	24271.0
2021-03-22 04:00:00	QQQ	ETF	314.11	314.78	313.93	314.73	49907.0
2021-03-22 04:30:00	QQQ	ETF	314.82	315.0	314.5	314.59	23895.0
2021-03-22 05:00:00	QQQ	ETF	314.68	315.01	314.5	315.01	15524.0
2021-03-22 05:30:00	QQQ	ETF	315.07	315.17	314.87	314.98	8657.0
2021-03-22 06:00:00	QQQ	ETF	314.98	315.84	314.95	315.84	47911.0
2021-03-22 06:30:00	QQQ	ETF	315.87	315.95	315.5	315.63	54842.0
2021-03-22 07:00:00	QQQ	ETF	315.58	316.04	315.39	315.94	82751.0
2021-03-22 07:30:00	QQQ	ETF	315.91	316.05	315.76	315.85	73992.0
2021-03-22 08:00:00	QQQ	ETF	315.86	316.07	314.0	315.33	182442.0
2021-03-22 08:30:00	QQQ	ETF	315.33	315.57	315.21	315.4	178756.0
2021-03-22 09:00:00	QQQ	ETF	315.41	315.7	315.2	315.26	194977.0
2021-03-22 09:30:00	QQQ	ETF	315.21	317.47	315.2	317.15	7079475.0
2021-03-22 10:00:00	QQQ	ETF	317.19	317.68	316.545	317.38	4744995.0
2021-03-22 10:30:00	QQQ	ETF	317.39	318.52	317.18	318.31	3258005.0
2021-03-22 11:00:00	QQQ	ETF	318.31	319.0	318.11	318.78	1851970.0
2021-03-22 11:30:00	QQQ	ETF	318.79	319.24	318.62	318.79	2166701.0
2021-03-22 12:00:00	QQQ	ETF	318.81	320.17	318.81	320.16	2271974.0
2021-03-22 12:30:00	QQQ	ETF	320.16	320.74	320.01	320.59	2849702.0

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

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