PREVIEW / etf_30min / 2021-03-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-10.parquet
  size:    631 KB
  rows:    24,308

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-10 04:00:00	SPY	ETF	387.51	387.7	387.17	387.6	11869.0
2021-03-10 04:30:00	SPY	ETF	387.58	387.98	387.58	387.94	7627.0
2021-03-10 05:00:00	SPY	ETF	387.85	388.15	387.8	387.84	38540.0
2021-03-10 05:30:00	SPY	ETF	387.8	387.8	387.13	387.19	66506.0
2021-03-10 06:00:00	SPY	ETF	387.17	387.51	386.39	386.56	74850.0
2021-03-10 06:30:00	SPY	ETF	386.54	387.18	386.49	387.18	20790.0
2021-03-10 07:00:00	SPY	ETF	387.14	387.66	386.93	387.51	60700.0
2021-03-10 07:30:00	SPY	ETF	387.49	387.64	387.0	387.3	51292.0
2021-03-10 08:00:00	SPY	ETF	386.9799	387.67	385.76	387.1	200285.0
2021-03-10 08:30:00	SPY	ETF	387.15	389.06	387.1	388.98	787472.0
2021-03-10 09:00:00	SPY	ETF	388.99	389.73	388.74	389.67	643922.0
2021-03-10 09:30:00	SPY	ETF	389.68	390.92	389.23	390.32	12829032.0
2021-03-10 10:00:00	SPY	ETF	390.32	390.82	388.43	388.495	8297644.0
2021-03-10 10:30:00	SPY	ETF	388.5	389.68	388.1702	389.35	8457845.0
2021-03-10 11:00:00	SPY	ETF	389.35	390.04	389.05	389.895	5567635.0
2021-03-10 11:30:00	SPY	ETF	389.895	390.56	389.08	390.105	4494861.0
2021-03-10 12:00:00	SPY	ETF	390.11	390.32	389.41	389.545	3253364.0
2021-03-10 12:30:00	SPY	ETF	389.549	390.32	389.03	390.2395	4495579.0
2021-03-10 13:00:00	SPY	ETF	390.24	390.73	388.89	390.38	6939850.0
2021-03-10 13:30:00	SPY	ETF	390.36	390.63	389.21	389.8702	4425665.0
2021-03-10 14:00:00	SPY	ETF	389.87	390.68	389.48	390.37	4670877.0
2021-03-10 14:30:00	SPY	ETF	390.37	391.4	390.22	390.815	4109883.0
2021-03-10 15:00:00	SPY	ETF	390.82	391.14	390.04	390.08	5084815.0
2021-03-10 15:30:00	SPY	ETF	390.075	390.42	389.36	389.5199	9837689.0
2021-03-10 16:00:00	SPY	ETF	389.51	390.48	389.38	390.3	4454842.0
2021-03-10 16:30:00	SPY	ETF	390.3	390.58	389.58	390.54	207089.0
2021-03-10 17:00:00	SPY	ETF	390.43	390.55	389.58	390.45	57425.0
2021-03-10 17:30:00	SPY	ETF	390.45	390.5	390.39	390.47	50454.0
2021-03-10 18:00:00	SPY	ETF	390.49	390.61	390.2	390.28	106212.0
2021-03-10 18:30:00	SPY	ETF	389.58	390.22	389.58	389.82	54705.0
2021-03-10 19:00:00	SPY	ETF	389.82	390.01	389.51	389.59	60801.0
2021-03-10 19:30:00	SPY	ETF	389.61	389.74	389.1	389.39	80419.0
2021-03-10 04:00:00	QQQ	ETF	311.8	312.19	311.23	311.85	45525.0
2021-03-10 04:30:00	QQQ	ETF	311.63	312.31	311.55	312.24	21750.0
2021-03-10 05:00:00	QQQ	ETF	312.16	312.56	311.99	312.23	20741.0
2021-03-10 05:30:00	QQQ	ETF	312.18	312.18	311.26	311.26	52838.0
2021-03-10 06:00:00	QQQ	ETF	311.19	311.39	309.8	310.0	116468.0
2021-03-10 06:30:00	QQQ	ETF	309.96	311.08	309.88	311.08	86962.0
2021-03-10 07:00:00	QQQ	ETF	311.04	311.74	310.79	311.48	177164.0
2021-03-10 07:30:00	QQQ	ETF	311.42	311.67	310.86	311.35	133385.0
2021-03-10 08:00:00	QQQ	ETF	311.0004	311.98	309.9604	310.801	266745.0
2021-03-10 08:30:00	QQQ	ETF	310.88	315.0	310.83	314.14	1721762.0
2021-03-10 09:00:00	QQQ	ETF	314.13	316.76	313.76	316.2	1482697.0
2021-03-10 09:30:00	QQQ	ETF	316.17	316.47	313.8	314.81	10142886.0
2021-03-10 10:00:00	QQQ	ETF	314.81	315.88	311.82	312.0	6075298.0
2021-03-10 10:30:00	QQQ	ETF	312.0	313.01	310.97	312.44	6613184.0
2021-03-10 11:00:00	QQQ	ETF	312.42	313.21	311.66	313.0126	3665464.0
2021-03-10 11:30:00	QQQ	ETF	313.02	313.53	311.31	313.03	3130962.0
2021-03-10 12:00:00	QQQ	ETF	313.025	313.21	311.55	311.72	2688339.0
2021-03-10 12:30:00	QQQ	ETF	311.68	312.94	310.73	312.755	3633084.0

> showing 50 of 24,308 rows — these rows as CSV

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