PREVIEW / etf_30min / 2021-01-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-19.parquet
  size:    640 KB
  rows:    24,456

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-19 04:00:00	SPY	ETF	377.7	378.19	377.7	377.82	46716.0
2021-01-19 04:30:00	SPY	ETF	377.8	378.46	377.79	378.28	12469.0
2021-01-19 05:00:00	SPY	ETF	378.36	378.39	378.05	378.15	23192.0
2021-01-19 05:30:00	SPY	ETF	378.15	378.53	378.15	378.32	41911.0
2021-01-19 06:00:00	SPY	ETF	378.36	378.72	378.36	378.67	21881.0
2021-01-19 06:30:00	SPY	ETF	378.69	378.69	378.52	378.64	21687.0
2021-01-19 07:00:00	SPY	ETF	378.65	378.67	378.25	378.28	179532.0
2021-01-19 07:30:00	SPY	ETF	378.26	378.45	378.1	378.45	68953.0
2021-01-19 08:00:00	SPY	ETF	378.46	378.68	377.85	378.3	228536.0
2021-01-19 08:30:00	SPY	ETF	378.32	378.4	375.7	378.15	661621.0
2021-01-19 09:00:00	SPY	ETF	378.18	378.49	378.15	378.28	181507.0
2021-01-19 09:30:00	SPY	ETF	378.34	378.77	377.08	377.71	5339031.0
2021-01-19 10:00:00	SPY	ETF	377.7199	377.88	377.04	377.56	3000720.0
2021-01-19 10:30:00	SPY	ETF	377.57	378.15	377.34	377.7	2235042.0
2021-01-19 11:00:00	SPY	ETF	377.7	377.99	376.75	377.385	2949062.0
2021-01-19 11:30:00	SPY	ETF	377.38	377.96	377.0	377.6514	1752102.0
2021-01-19 12:00:00	SPY	ETF	377.6586	378.12	377.58	377.91	2231744.0
2021-01-19 12:30:00	SPY	ETF	377.91	378.81	377.9	378.73	2539276.0
2021-01-19 13:00:00	SPY	ETF	378.72	379.02	378.64	378.7299	1567690.0
2021-01-19 13:30:00	SPY	ETF	378.7287	379.23	378.67	379.1086	1929369.0
2021-01-19 14:00:00	SPY	ETF	379.11	379.16	378.82	378.91	3653047.0
2021-01-19 14:30:00	SPY	ETF	378.92	379.03	378.53	378.84	2892760.0
2021-01-19 15:00:00	SPY	ETF	378.835	379.1	378.75	378.8597	3550857.0
2021-01-19 15:30:00	SPY	ETF	378.8559	379.19	378.59	378.63	8616408.0
2021-01-19 16:00:00	SPY	ETF	378.63	378.72	378.39	378.58	5886390.0
2021-01-19 16:30:00	SPY	ETF	378.58	378.9899	378.51	378.9	256840.0
2021-01-19 17:00:00	SPY	ETF	378.9	378.9	378.72	378.8	20410.0
2021-01-19 17:30:00	SPY	ETF	378.8	379.05	378.8	379.05	47917.0
2021-01-19 18:00:00	SPY	ETF	379.1	379.85	379.02	379.84	98515.0
2021-01-19 18:30:00	SPY	ETF	379.85	379.85	379.59	379.84	27305.0
2021-01-19 19:00:00	SPY	ETF	379.81	379.81	379.35	379.45	20856.0
2021-01-19 19:30:00	SPY	ETF	379.34	379.5	379.28	379.31	138103.0
2021-01-19 04:00:00	QQQ	ETF	314.29	314.88	314.29	314.74	44604.0
2021-01-19 04:30:00	QQQ	ETF	314.72	315.04	314.7	314.95	29890.0
2021-01-19 05:00:00	QQQ	ETF	315.08	315.15	314.88	314.95	10372.0
2021-01-19 05:30:00	QQQ	ETF	314.97	315.13	314.89	315.01	10746.0
2021-01-19 06:00:00	QQQ	ETF	315.03	315.23	315.02	315.15	8208.0
2021-01-19 06:30:00	QQQ	ETF	315.15	315.18	315.04	315.14	35532.0
2021-01-19 07:00:00	QQQ	ETF	315.14	315.14	314.63	314.77	147230.0
2021-01-19 07:30:00	QQQ	ETF	314.65	314.65	314.2	314.46	66420.0
2021-01-19 08:00:00	QQQ	ETF	314.41	315.1296	314.23	314.28	472340.0
2021-01-19 08:30:00	QQQ	ETF	314.3	314.45	314.14	314.23	54669.0
2021-01-19 09:00:00	QQQ	ETF	314.2	314.53	314.13	314.25	114245.0
2021-01-19 09:30:00	QQQ	ETF	314.23	315.09	313.4	313.97	3960272.0
2021-01-19 10:00:00	QQQ	ETF	313.98	314.69	313.32	313.94	1630792.0
2021-01-19 10:30:00	QQQ	ETF	313.98	314.39	313.54	313.86	1167505.0
2021-01-19 11:00:00	QQQ	ETF	313.85	314.35	313.12	313.59	1223861.0
2021-01-19 11:30:00	QQQ	ETF	313.57	314.53	313.46	314.355	740783.0
2021-01-19 12:00:00	QQQ	ETF	314.36	314.89	314.27	314.83	777930.0
2021-01-19 12:30:00	QQQ	ETF	314.82	315.75	314.8	315.7	925091.0

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

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