PREVIEW / etf_30min / 2021-10-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-27.parquet
  size:    635 KB
  rows:    24,105

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-10-27 04:00:00	SPY	ETF	456.77	456.9	456.57	456.64	14666.0
2021-10-27 04:30:00	SPY	ETF	456.66	456.66	456.03	456.04	12548.0
2021-10-27 05:00:00	SPY	ETF	456.01	456.01	455.4	455.91	7980.0
2021-10-27 05:30:00	SPY	ETF	455.81	455.81	455.37	455.46	18925.0
2021-10-27 06:00:00	SPY	ETF	455.58	455.77	455.58	455.73	23615.0
2021-10-27 06:30:00	SPY	ETF	455.76	456.07	455.21	455.51	13968.0
2021-10-27 07:00:00	SPY	ETF	455.51	456.08	455.43	455.95	41416.0
2021-10-27 07:30:00	SPY	ETF	455.96	456.13	455.53	455.53	57592.0
2021-10-27 08:00:00	SPY	ETF	455.9199	456.69	455.48	456.28	203767.0
2021-10-27 08:30:00	SPY	ETF	456.14	456.57	456.1	456.41	217118.0
2021-10-27 09:00:00	SPY	ETF	456.42	456.65	456.33	456.46	146429.0
2021-10-27 09:30:00	SPY	ETF	456.45	457.0583	455.33	457.03	5042390.0
2021-10-27 10:00:00	SPY	ETF	457.03	457.16	455.68	455.85	3700603.0
2021-10-27 10:30:00	SPY	ETF	455.85	456.3794	455.54	455.73	2973392.0
2021-10-27 11:00:00	SPY	ETF	455.73	456.44	455.61	456.15	2096649.0
2021-10-27 11:30:00	SPY	ETF	456.16	456.31	455.66	455.91	1586491.0
2021-10-27 12:00:00	SPY	ETF	455.94	456.5	455.78	456.31	1154613.0
2021-10-27 12:30:00	SPY	ETF	456.34	456.34	455.91	456.1946	1131470.0
2021-10-27 13:00:00	SPY	ETF	456.19	456.92	456.11	456.79	1516539.0
2021-10-27 13:30:00	SPY	ETF	456.785	456.97	456.6	456.96	1097916.0
2021-10-27 14:00:00	SPY	ETF	456.96	457.13	456.68	456.73	2071416.0
2021-10-27 14:30:00	SPY	ETF	456.74	456.79	456.185	456.2	1446587.0
2021-10-27 15:00:00	SPY	ETF	456.19	456.29	454.55	455.325	5711391.0
2021-10-27 15:30:00	SPY	ETF	455.325	455.36	453.86	453.9	10257433.0
2021-10-27 16:00:00	SPY	ETF	453.91	454.31	453.8281	454.08	2824112.0
2021-10-27 16:30:00	SPY	ETF	454.09	454.32	453.93	454.3	16265621.0
2021-10-27 17:00:00	SPY	ETF	454.2	454.37	454.2	454.25	55466.0
2021-10-27 17:30:00	SPY	ETF	454.25	454.36	454.21	454.3	10189.0
2021-10-27 18:00:00	SPY	ETF	454.34	454.59	454.34	454.58	67989.0
2021-10-27 18:30:00	SPY	ETF	453.94	454.71	453.94	454.67	33848.0
2021-10-27 19:00:00	SPY	ETF	454.7	454.8	454.56	454.7	17400.0
2021-10-27 19:30:00	SPY	ETF	454.6	454.94	454.6	454.85	40754.0
2021-10-27 04:00:00	QQQ	ETF	379.73	379.93	379.55	379.64	48713.0
2021-10-27 04:30:00	QQQ	ETF	379.67	379.67	379.1	379.16	9136.0
2021-10-27 05:00:00	QQQ	ETF	379.0	379.12	378.59	378.95	28973.0
2021-10-27 05:30:00	QQQ	ETF	379.06	379.06	378.31	378.37	22202.0
2021-10-27 06:00:00	QQQ	ETF	378.35	378.71	378.33	378.55	48742.0
2021-10-27 06:30:00	QQQ	ETF	378.59	378.77	378.09	378.28	45429.0
2021-10-27 07:00:00	QQQ	ETF	378.28	378.76	378.28	378.6	141373.0
2021-10-27 07:30:00	QQQ	ETF	378.66	378.78	378.22	378.24	119111.0
2021-10-27 08:00:00	QQQ	ETF	378.42	379.97	378.22	379.01	250491.0
2021-10-27 08:30:00	QQQ	ETF	379.01	379.651	379.01	379.45	201586.0
2021-10-27 09:00:00	QQQ	ETF	379.46	379.83	379.44	379.58	269043.0
2021-10-27 09:30:00	QQQ	ETF	379.58	381.41	379.31	381.32	4395320.0
2021-10-27 10:00:00	QQQ	ETF	381.32	381.47	379.37	380.67	3337615.0
2021-10-27 10:30:00	QQQ	ETF	380.69	381.76	380.1501	380.75	2434750.0
2021-10-27 11:00:00	QQQ	ETF	380.76	381.83	380.6101	381.52	1507656.0
2021-10-27 11:30:00	QQQ	ETF	381.51	381.71	381.04	381.62	1592285.0
2021-10-27 12:00:00	QQQ	ETF	381.625	382.22	381.535	381.98	1448186.0
2021-10-27 12:30:00	QQQ	ETF	381.99	382.38	381.9	382.17	947302.0

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

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