PREVIEW / etf_30min / 2020-05-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-08.parquet
  size:    552 KB
  rows:    20,415

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-08 04:00:00	SPY	ETF	291.0	291.0	290.43	290.65	54823.0
2020-05-08 04:30:00	SPY	ETF	290.66	291.0	290.66	290.98	13588.0
2020-05-08 05:00:00	SPY	ETF	290.85	291.23	290.85	291.21	19466.0
2020-05-08 05:30:00	SPY	ETF	291.14	291.56	290.85	291.56	22133.0
2020-05-08 06:00:00	SPY	ETF	291.5	291.68	291.38	291.55	24291.0
2020-05-08 06:30:00	SPY	ETF	291.65	291.74	291.5	291.5	46341.0
2020-05-08 07:00:00	SPY	ETF	291.48	291.48	291.12	291.43	116216.0
2020-05-08 07:30:00	SPY	ETF	291.4	291.46	290.87	290.9	146471.0
2020-05-08 08:00:00	SPY	ETF	290.9	292.23	290.48	290.72	572142.0
2020-05-08 08:30:00	SPY	ETF	290.76	292.05	290.76	291.32	1300896.0
2020-05-08 09:00:00	SPY	ETF	291.32	291.75	290.92	291.05	613942.0
2020-05-08 09:30:00	SPY	ETF	291.09	291.37	289.86	290.8	6963390.0
2020-05-08 10:00:00	SPY	ETF	290.79	291.53	290.79	291.08	5197475.0
2020-05-08 10:30:00	SPY	ETF	291.08	291.39	290.54	290.84	3893947.0
2020-05-08 11:00:00	SPY	ETF	290.83	291.64	290.43	291.485	4084416.0
2020-05-08 11:30:00	SPY	ETF	291.485	291.85	291.445	291.73	3093419.0
2020-05-08 12:00:00	SPY	ETF	291.72	291.99	291.49	291.67	2540190.0
2020-05-08 12:30:00	SPY	ETF	291.67	292.0	291.66	291.945	2162970.0
2020-05-08 13:00:00	SPY	ETF	291.94	292.05	291.34	291.46	3082508.0
2020-05-08 13:30:00	SPY	ETF	291.46	291.596	290.76	291.1099	2964406.0
2020-05-08 14:00:00	SPY	ETF	291.11	291.63	290.79	291.55	3100818.0
2020-05-08 14:30:00	SPY	ETF	291.555	291.75	291.16	291.66	3552433.0
2020-05-08 15:00:00	SPY	ETF	291.67	292.14	291.49	291.9434	6722935.0
2020-05-08 15:30:00	SPY	ETF	291.94	292.95	291.85	292.47	14055518.0
2020-05-08 16:00:00	SPY	ETF	292.46	293.28	291.6702	293.12	9529701.0
2020-05-08 16:30:00	SPY	ETF	293.0	293.54	293.0	293.33	1087827.0
2020-05-08 17:00:00	SPY	ETF	293.37	293.49	293.31	293.4	477845.0
2020-05-08 17:30:00	SPY	ETF	293.39	293.49	292.44	293.3	114737.0
2020-05-08 18:00:00	SPY	ETF	293.3	293.45	293.3	293.4	31830.0
2020-05-08 18:30:00	SPY	ETF	293.4	293.49	293.37	293.45	36919.0
2020-05-08 19:00:00	SPY	ETF	293.49	293.57	293.45	293.57	27871.0
2020-05-08 19:30:00	SPY	ETF	293.51	293.74	293.51	293.74	76471.0
2020-05-08 04:00:00	QQQ	ETF	224.12	224.24	223.78	223.9	26668.0
2020-05-08 04:30:00	QQQ	ETF	223.82	224.14	223.8	224.12	6500.0
2020-05-08 05:00:00	QQQ	ETF	224.2	224.35	224.13	224.29	7422.0
2020-05-08 05:30:00	QQQ	ETF	224.29	224.51	224.0	224.41	20928.0
2020-05-08 06:00:00	QQQ	ETF	224.51	224.72	224.45	224.62	14276.0
2020-05-08 06:30:00	QQQ	ETF	224.58	224.78	224.58	224.69	91609.0
2020-05-08 07:00:00	QQQ	ETF	224.6	224.69	224.37	224.64	134564.0
2020-05-08 07:30:00	QQQ	ETF	224.61	224.64	224.29	224.34	132885.0
2020-05-08 08:00:00	QQQ	ETF	224.35	224.91	221.82	224.03	191582.0
2020-05-08 08:30:00	QQQ	ETF	224.22	224.94	224.0	224.18	528135.0
2020-05-08 09:00:00	QQQ	ETF	224.15	224.45	223.45	223.52	196731.0
2020-05-08 09:30:00	QQQ	ETF	223.55	223.74	222.48	223.13	4413060.0
2020-05-08 10:00:00	QQQ	ETF	223.14	224.2	223.14	224.11	2889653.0
2020-05-08 10:30:00	QQQ	ETF	224.11	224.391	223.61	223.85	1771974.0
2020-05-08 11:00:00	QQQ	ETF	223.85	224.1	223.505	224.0	1575306.0
2020-05-08 11:30:00	QQQ	ETF	223.98	224.69	223.96	224.6	1362895.0
2020-05-08 12:00:00	QQQ	ETF	224.61	224.83	224.42	224.596	1151694.0
2020-05-08 12:30:00	QQQ	ETF	224.6031	224.93	224.57	224.86	1035711.0

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

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