PREVIEW / etf_30min / 2021-01-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-20.parquet
  size:    632 KB
  rows:    23,804

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-01-20 04:00:00	SPY	ETF	379.63	379.82	379.48	379.82	11500.0
2021-01-20 04:30:00	SPY	ETF	379.69	379.86	379.56	379.86	8637.0
2021-01-20 05:00:00	SPY	ETF	379.83	380.0	379.8	379.96	11131.0
2021-01-20 05:30:00	SPY	ETF	380.0	380.35	379.98	380.3	8026.0
2021-01-20 06:00:00	SPY	ETF	380.25	380.33	380.1	380.1	7115.0
2021-01-20 06:30:00	SPY	ETF	380.04	380.05	379.9	379.98	14863.0
2021-01-20 07:00:00	SPY	ETF	379.94	380.03	379.8	379.88	91910.0
2021-01-20 07:30:00	SPY	ETF	379.94	380.09	379.86	380.04	106640.0
2021-01-20 08:00:00	SPY	ETF	380.0	380.55	379.13	380.42	210942.0
2021-01-20 08:30:00	SPY	ETF	380.44	380.65	380.31	380.64	120766.0
2021-01-20 09:00:00	SPY	ETF	380.66	381.12	380.66	381.1	218531.0
2021-01-20 09:30:00	SPY	ETF	381.11	381.6	380.69	381.3328	4114421.0
2021-01-20 10:00:00	SPY	ETF	381.34	382.89	381.34	382.399	4335544.0
2021-01-20 10:30:00	SPY	ETF	382.39	383.082	382.33	382.7718	2913541.0
2021-01-20 11:00:00	SPY	ETF	382.77	382.9	382.18	382.6	2600254.0
2021-01-20 11:30:00	SPY	ETF	382.602	383.08	382.5011	382.92	1428159.0
2021-01-20 12:00:00	SPY	ETF	382.92	383.42	382.92	383.3613	1445042.0
2021-01-20 12:30:00	SPY	ETF	383.365	383.76	383.35	383.65	1646777.0
2021-01-20 13:00:00	SPY	ETF	383.65	384.18	383.65	383.99	2046286.0
2021-01-20 13:30:00	SPY	ETF	383.985	384.26	383.615	383.84	1544756.0
2021-01-20 14:00:00	SPY	ETF	383.85	383.99	383.41	383.99	1728837.0
2021-01-20 14:30:00	SPY	ETF	383.99	384.42	383.89	384.1469	1908177.0
2021-01-20 15:00:00	SPY	ETF	384.145	384.38	383.82	384.29	2742066.0
2021-01-20 15:30:00	SPY	ETF	384.3	384.79	383.83	383.86	7564307.0
2021-01-20 16:00:00	SPY	ETF	383.84	384.1	383.55	383.87	3562923.0
2021-01-20 16:30:00	SPY	ETF	383.87	383.97	383.56	383.62	245387.0
2021-01-20 17:00:00	SPY	ETF	383.55	383.89	383.55	383.82	76794.0
2021-01-20 17:30:00	SPY	ETF	383.79	383.81	383.71	383.75	17872.0
2021-01-20 18:00:00	SPY	ETF	383.75	384.33	383.7	384.32	94836.0
2021-01-20 18:30:00	SPY	ETF	383.89	384.49	383.89	384.32	49521.0
2021-01-20 19:00:00	SPY	ETF	384.29	384.6	384.0	384.2	45819.0
2021-01-20 19:30:00	SPY	ETF	384.15	384.63	384.1	384.57	39944.0
2021-01-20 04:00:00	QQQ	ETF	318.45	318.5	318.2	318.41	20405.0
2021-01-20 04:30:00	QQQ	ETF	318.48	318.8	318.26	318.8	10136.0
2021-01-20 05:00:00	QQQ	ETF	318.71	318.92	318.68	318.85	11081.0
2021-01-20 05:30:00	QQQ	ETF	318.88	319.2	318.75	319.2	8500.0
2021-01-20 06:00:00	QQQ	ETF	319.12	319.15	318.91	318.91	16230.0
2021-01-20 06:30:00	QQQ	ETF	318.9	319.04	318.81	319.04	21025.0
2021-01-20 07:00:00	QQQ	ETF	319.01	319.05	318.82	318.85	103497.0
2021-01-20 07:30:00	QQQ	ETF	318.9	319.41	318.9	319.41	87164.0
2021-01-20 08:00:00	QQQ	ETF	318.9999	319.55	316.41	319.32	147153.0
2021-01-20 08:30:00	QQQ	ETF	319.37	319.76	319.32	319.74	270922.0
2021-01-20 09:00:00	QQQ	ETF	319.73	320.17	319.73	320.12	201670.0
2021-01-20 09:30:00	QQQ	ETF	320.14	321.541	319.77	320.79	3877487.0
2021-01-20 10:00:00	QQQ	ETF	320.81	322.58	320.8	322.4199	2585933.0
2021-01-20 10:30:00	QQQ	ETF	322.41	322.85	322.31	322.58	1691174.0
2021-01-20 11:00:00	QQQ	ETF	322.57	323.0	321.8	322.71	2022453.0
2021-01-20 11:30:00	QQQ	ETF	322.72	322.9399	322.435	322.85	962568.0
2021-01-20 12:00:00	QQQ	ETF	322.86	323.1	322.69	322.96	980323.0
2021-01-20 12:30:00	QQQ	ETF	322.95	323.4799	322.94	323.305	910949.0

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

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