PREVIEW / etf_30min / 2022-06-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-09.parquet
  size:    649 KB
  rows:    25,844

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
2022-06-09 04:00:00	SPY	ETF	411.28	411.33	410.8	411.27	5837.0
2022-06-09 04:30:00	SPY	ETF	411.32	412.93	411.32	412.91	15890.0
2022-06-09 05:00:00	SPY	ETF	412.85	412.98	412.52	412.7	19007.0
2022-06-09 05:30:00	SPY	ETF	412.63	412.89	412.38	412.38	15272.0
2022-06-09 06:00:00	SPY	ETF	412.59	413.76	412.29	413.66	46294.0
2022-06-09 06:30:00	SPY	ETF	413.71	413.93	413.31	413.51	136247.0
2022-06-09 07:00:00	SPY	ETF	413.46	414.2	413.16	413.39	113324.0
2022-06-09 07:30:00	SPY	ETF	413.34	413.97	411.98	412.35	217172.0
2022-06-09 08:00:00	SPY	ETF	413.4099	414.1301	410.5	411.3	408386.0
2022-06-09 08:30:00	SPY	ETF	411.3	411.62	409.54	409.97	494800.0
2022-06-09 09:00:00	SPY	ETF	409.89	410.29	409.09	409.34	526366.0
2022-06-09 09:30:00	SPY	ETF	409.33	411.69	408.42	411.65	5921642.0
2022-06-09 10:00:00	SPY	ETF	411.65	411.74	409.01	410.695	3475752.0
2022-06-09 10:30:00	SPY	ETF	410.71	411.34	408.63	409.36	3304717.0
2022-06-09 11:00:00	SPY	ETF	409.35	409.5	408.11	408.84	3071687.0
2022-06-09 11:30:00	SPY	ETF	408.8343	410.35	408.44	409.43	2694723.0
2022-06-09 12:00:00	SPY	ETF	409.44	409.735	408.3	409.5032	2681285.0
2022-06-09 12:30:00	SPY	ETF	409.5	410.53	409.2001	410.34	2125017.0
2022-06-09 13:00:00	SPY	ETF	410.34	410.95	409.1316	409.3399	2332690.0
2022-06-09 13:30:00	SPY	ETF	409.32	409.4869	408.28	409.43	2676939.0
2022-06-09 14:00:00	SPY	ETF	409.43	409.44	407.88	408.38	2980497.0
2022-06-09 14:30:00	SPY	ETF	408.39	408.39	406.59	406.62	3861631.0
2022-06-09 15:00:00	SPY	ETF	406.61	406.7	404.4774	404.49	5959776.0
2022-06-09 15:30:00	SPY	ETF	404.5	404.645	401.45	401.47	16890304.0
2022-06-09 16:00:00	SPY	ETF	401.48	401.99	401.43	401.91	4556276.0
2022-06-09 16:30:00	SPY	ETF	401.99	402.33	401.44	402.29	436651.0
2022-06-09 17:00:00	SPY	ETF	402.19	402.36	402.0	402.27	94326.0
2022-06-09 17:30:00	SPY	ETF	402.17	402.61	402.17	402.47	72612.0
2022-06-09 18:00:00	SPY	ETF	402.47	402.5	401.69	401.78	70788.0
2022-06-09 18:30:00	SPY	ETF	401.76	402.1	401.71	401.87	23790.0
2022-06-09 19:00:00	SPY	ETF	401.9	402.26	401.79	402.15	21311.0
2022-06-09 19:30:00	SPY	ETF	402.1	402.39	401.28	402.1	49418.0
2022-06-09 04:00:00	QQQ	ETF	307.5	307.67	307.07	307.44	37413.0
2022-06-09 04:30:00	QQQ	ETF	307.6	309.16	307.59	309.13	56622.0
2022-06-09 05:00:00	QQQ	ETF	309.12	309.3	308.76	308.87	44930.0
2022-06-09 05:30:00	QQQ	ETF	308.91	309.15	308.64	308.78	17927.0
2022-06-09 06:00:00	QQQ	ETF	308.83	310.1	308.55	310.08	22383.0
2022-06-09 06:30:00	QQQ	ETF	310.1	310.33	309.48	309.54	55829.0
2022-06-09 07:00:00	QQQ	ETF	309.47	310.11	309.03	309.4	109491.0
2022-06-09 07:30:00	QQQ	ETF	309.43	309.99	308.14	308.35	239342.0
2022-06-09 08:00:00	QQQ	ETF	309.21	310.0	306.84	307.36	481511.0
2022-06-09 08:30:00	QQQ	ETF	307.46	307.82	305.81	306.2104	507420.0
2022-06-09 09:00:00	QQQ	ETF	306.21	306.49	305.56	305.86	437741.0
2022-06-09 09:30:00	QQQ	ETF	305.91	308.62	305.01	308.245	6267957.0
2022-06-09 10:00:00	QQQ	ETF	308.25	308.47	306.2	308.4529	3125881.0
2022-06-09 10:30:00	QQQ	ETF	308.485	309.05	306.4	306.86	2531344.0
2022-06-09 11:00:00	QQQ	ETF	306.86	307.0	305.66	306.26	2191025.0
2022-06-09 11:30:00	QQQ	ETF	306.24	307.615	305.75	306.61	1668395.0
2022-06-09 12:00:00	QQQ	ETF	306.62	306.9	305.5	306.52	1237826.0
2022-06-09 12:30:00	QQQ	ETF	306.53	307.2	306.065	306.94	1262545.0

> showing 50 of 25,844 rows — these rows as CSV

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