PREVIEW / etf_30min / 2020-05-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-12.parquet
  size:    556 KB
  rows:    20,506

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
2020-05-12 04:00:00	SPY	ETF	291.82	292.2	291.37	292.14	27974.0
2020-05-12 04:30:00	SPY	ETF	292.05	292.05	291.72	291.75	6099.0
2020-05-12 05:00:00	SPY	ETF	291.65	292.22	291.33	292.21	32721.0
2020-05-12 05:30:00	SPY	ETF	291.84	292.5	291.59	292.48	58053.0
2020-05-12 06:00:00	SPY	ETF	292.4	293.2	292.23	293.12	80861.0
2020-05-12 06:30:00	SPY	ETF	293.15	293.29	292.92	293.0	43868.0
2020-05-12 07:00:00	SPY	ETF	293.04	293.74	292.94	293.72	209423.0
2020-05-12 07:30:00	SPY	ETF	293.72	293.93	293.31	293.83	324334.0
2020-05-12 08:00:00	SPY	ETF	293.76	293.89	290.31	293.5	219776.0
2020-05-12 08:30:00	SPY	ETF	293.5	293.85	293.11	293.77	212320.0
2020-05-12 09:00:00	SPY	ETF	293.8	293.97	293.5	293.72	351266.0
2020-05-12 09:30:00	SPY	ETF	293.79	294.24	291.54	292.283	8789003.0
2020-05-12 10:00:00	SPY	ETF	292.28	292.69	291.85	292.03	6232415.0
2020-05-12 10:30:00	SPY	ETF	292.04	292.77	291.61	292.53	4104690.0
2020-05-12 11:00:00	SPY	ETF	292.54	293.13	292.275	292.685	3887247.0
2020-05-12 11:30:00	SPY	ETF	292.675	292.95	291.95	292.51	2480483.0
2020-05-12 12:00:00	SPY	ETF	292.52	292.6294	292.0	292.485	2323782.0
2020-05-12 12:30:00	SPY	ETF	292.48	292.64	292.17	292.51	2304285.0
2020-05-12 13:00:00	SPY	ETF	292.5	292.56	290.5	290.795	5202393.0
2020-05-12 13:30:00	SPY	ETF	290.8	291.49	290.67	291.484	2831313.0
2020-05-12 14:00:00	SPY	ETF	291.4742	291.56	290.28	290.85	5268184.0
2020-05-12 14:30:00	SPY	ETF	290.84	291.27	290.24	291.04	3985145.0
2020-05-12 15:00:00	SPY	ETF	291.04	291.12	289.56	289.63	8209544.0
2020-05-12 15:30:00	SPY	ETF	289.635	289.89	286.55	286.62	25987764.0
2020-05-12 16:00:00	SPY	ETF	286.59	286.67	285.35	285.57	7663627.0
2020-05-12 16:30:00	SPY	ETF	285.4	286.67	284.13	284.3	2412989.0
2020-05-12 17:00:00	SPY	ETF	284.32	284.43	283.9	284.15	446450.0
2020-05-12 17:30:00	SPY	ETF	284.19	286.67	284.19	284.49	171811.0
2020-05-12 18:00:00	SPY	ETF	284.45	286.6721	283.68	284.7	586712.0
2020-05-12 18:30:00	SPY	ETF	284.74	285.01	284.42	284.64	220104.0
2020-05-12 19:00:00	SPY	ETF	284.68	284.95	284.4	284.75	100507.0
2020-05-12 19:30:00	SPY	ETF	284.75	284.89	283.1	283.3	468158.0
2020-05-12 04:00:00	QQQ	ETF	226.42	226.65	226.14	226.53	25406.0
2020-05-12 04:30:00	QQQ	ETF	226.46	226.52	226.18	226.22	12729.0
2020-05-12 05:00:00	QQQ	ETF	226.11	226.34	225.74	226.3	13184.0
2020-05-12 05:30:00	QQQ	ETF	226.25	226.47	225.9	226.46	13659.0
2020-05-12 06:00:00	QQQ	ETF	226.5	226.97	226.3	226.97	21484.0
2020-05-12 06:30:00	QQQ	ETF	226.95	227.1	226.78	227.0	23560.0
2020-05-12 07:00:00	QQQ	ETF	226.85	227.58	226.79	227.51	67700.0
2020-05-12 07:30:00	QQQ	ETF	227.52	227.54	227.18	227.4	95920.0
2020-05-12 08:00:00	QQQ	ETF	227.4	227.56	225.72	227.23	118596.0
2020-05-12 08:30:00	QQQ	ETF	227.2	227.53	226.87	227.44	203755.0
2020-05-12 09:00:00	QQQ	ETF	227.47	227.63	227.15	227.44	214352.0
2020-05-12 09:30:00	QQQ	ETF	227.46	228.095	225.46	226.265	5284335.0
2020-05-12 10:00:00	QQQ	ETF	226.28	226.92	225.8201	226.58	2693851.0
2020-05-12 10:30:00	QQQ	ETF	226.57	227.43	226.39	227.24	2263331.0
2020-05-12 11:00:00	QQQ	ETF	227.25	227.78	227.16	227.35	1986347.0
2020-05-12 11:30:00	QQQ	ETF	227.36	227.5599	226.82	227.26	1534793.0
2020-05-12 12:00:00	QQQ	ETF	227.28	227.51	226.95	227.47	1194038.0
2020-05-12 12:30:00	QQQ	ETF	227.465	227.75	227.28	227.68	1567749.0

> showing 50 of 20,506 rows — these rows as CSV

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