PREVIEW / etf_30min / 2021-04-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-05.parquet
  size:    649 KB
  rows:    25,023

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-04-05 04:00:00	SPY	ETF	402.12	402.43	402.08	402.34	19543.0
2021-04-05 04:30:00	SPY	ETF	402.55	402.56	402.38	402.39	4632.0
2021-04-05 05:00:00	SPY	ETF	402.39	402.66	402.39	402.66	7255.0
2021-04-05 05:30:00	SPY	ETF	402.63	402.75	402.63	402.67	6918.0
2021-04-05 06:00:00	SPY	ETF	402.54	402.86	402.52	402.81	7841.0
2021-04-05 06:30:00	SPY	ETF	402.81	402.87	402.66	402.72	9814.0
2021-04-05 07:00:00	SPY	ETF	402.74	402.99	402.65	402.95	159077.0
2021-04-05 07:30:00	SPY	ETF	402.95	402.95	402.73	402.85	69492.0
2021-04-05 08:00:00	SPY	ETF	402.7404	402.9796	401.73	402.91	86093.0
2021-04-05 08:30:00	SPY	ETF	402.91	403.44	402.9	403.33	188893.0
2021-04-05 09:00:00	SPY	ETF	403.35	403.55	403.25	403.49	445573.0
2021-04-05 09:30:00	SPY	ETF	403.46	404.63	403.38	404.55	8264866.0
2021-04-05 10:00:00	SPY	ETF	404.57	405.49	404.22	405.31	6538118.0
2021-04-05 10:30:00	SPY	ETF	405.3099	406.03	405.3	405.63	4603062.0
2021-04-05 11:00:00	SPY	ETF	405.63	405.97	405.485	405.71	2390293.0
2021-04-05 11:30:00	SPY	ETF	405.71	406.5	405.69	406.22	3478123.0
2021-04-05 12:00:00	SPY	ETF	406.21	406.67	406.21	406.59	2290908.0
2021-04-05 12:30:00	SPY	ETF	406.59	406.94	406.16	406.36	3162279.0
2021-04-05 13:00:00	SPY	ETF	406.355	406.61	406.17	406.26	2369238.0
2021-04-05 13:30:00	SPY	ETF	406.26	406.59	406.08	406.59	2362872.0
2021-04-05 14:00:00	SPY	ETF	406.58	406.6	406.33	406.39	2131860.0
2021-04-05 14:30:00	SPY	ETF	406.39	406.83	406.1001	406.115	3492649.0
2021-04-05 15:00:00	SPY	ETF	406.1101	406.43	405.75	406.01	5247512.0
2021-04-05 15:30:00	SPY	ETF	406.02	406.84	405.833	406.31	12200521.0
2021-04-05 16:00:00	SPY	ETF	406.3	406.53	406.1	406.45	3643075.0
2021-04-05 16:30:00	SPY	ETF	406.46	406.66	406.36	406.59	268152.0
2021-04-05 17:00:00	SPY	ETF	406.59	406.65	406.36	406.46	90164.0
2021-04-05 17:30:00	SPY	ETF	406.48	406.55	406.45	406.55	34989.0
2021-04-05 18:00:00	SPY	ETF	406.53	406.6	406.46	406.5	46157.0
2021-04-05 18:30:00	SPY	ETF	406.36	406.98	406.36	406.89	42603.0
2021-04-05 19:00:00	SPY	ETF	406.9	406.99	406.87	406.93	33114.0
2021-04-05 19:30:00	SPY	ETF	406.93	406.93	406.71	406.74	21118.0
2021-04-05 04:00:00	QQQ	ETF	326.23	326.23	324.75	325.32	60682.0
2021-04-05 04:30:00	QQQ	ETF	325.38	325.78	325.38	325.63	29323.0
2021-04-05 05:00:00	QQQ	ETF	325.52	326.01	325.49	325.99	14219.0
2021-04-05 05:30:00	QQQ	ETF	326.01	326.25	325.96	326.01	18018.0
2021-04-05 06:00:00	QQQ	ETF	326.1	326.26	325.94	326.19	16961.0
2021-04-05 06:30:00	QQQ	ETF	326.11	326.11	325.64	325.7	37734.0
2021-04-05 07:00:00	QQQ	ETF	325.73	326.23	325.7	326.04	145576.0
2021-04-05 07:30:00	QQQ	ETF	326.01	326.29	325.85	326.25	94612.0
2021-04-05 08:00:00	QQQ	ETF	326.25	326.37	324.49	326.16	122687.0
2021-04-05 08:30:00	QQQ	ETF	326.18	327.46	326.18	327.22	207989.0
2021-04-05 09:00:00	QQQ	ETF	327.25	327.38	327.03	327.16	192868.0
2021-04-05 09:30:00	QQQ	ETF	327.11	328.74	326.88	328.52	4593503.0
2021-04-05 10:00:00	QQQ	ETF	328.54	329.51	328.06	329.42	3634240.0
2021-04-05 10:30:00	QQQ	ETF	329.44	330.0	329.36	329.445	2290211.0
2021-04-05 11:00:00	QQQ	ETF	329.485	329.9101	329.26	329.705	977796.0
2021-04-05 11:30:00	QQQ	ETF	329.69	330.48	329.59	330.05	2070054.0
2021-04-05 12:00:00	QQQ	ETF	330.06	330.8199	330.06	330.661	1443988.0
2021-04-05 12:30:00	QQQ	ETF	330.68	331.02	330.53	330.76	1453209.0

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

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