PREVIEW / etf_30min / 2021-06-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-16.parquet
  size:    603 KB
  rows:    23,144

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-06-16 04:00:00	SPY	ETF	424.22	424.22	424.0	424.0	2915.0
2021-06-16 04:30:00	SPY	ETF	423.88	424.23	423.88	424.22	6519.0
2021-06-16 05:00:00	SPY	ETF	424.3	424.32	423.93	424.01	12001.0
2021-06-16 05:30:00	SPY	ETF	423.98	424.18	423.98	424.14	1611.0
2021-06-16 06:00:00	SPY	ETF	424.15	424.59	424.06	424.54	8414.0
2021-06-16 06:30:00	SPY	ETF	424.63	424.69	424.27	424.27	14827.0
2021-06-16 07:00:00	SPY	ETF	424.2	424.3	424.1	424.13	12260.0
2021-06-16 07:30:00	SPY	ETF	424.18	424.25	424.08	424.12	18998.0
2021-06-16 08:00:00	SPY	ETF	424.2401	424.3404	423.98	424.25	37599.0
2021-06-16 08:30:00	SPY	ETF	424.27	424.43	424.25	424.35	26906.0
2021-06-16 09:00:00	SPY	ETF	424.4	424.73	424.33	424.64	128343.0
2021-06-16 09:30:00	SPY	ETF	424.63	424.87	424.13	424.3088	2836223.0
2021-06-16 10:00:00	SPY	ETF	424.3	424.58	424.18	424.285	1902815.0
2021-06-16 10:30:00	SPY	ETF	424.28	424.36	424.05	424.215	1464560.0
2021-06-16 11:00:00	SPY	ETF	424.21	424.57	424.1	424.505	1170997.0
2021-06-16 11:30:00	SPY	ETF	424.5	424.52	424.2	424.23	884210.0
2021-06-16 12:00:00	SPY	ETF	424.235	424.34	423.265	423.5201	1894124.0
2021-06-16 12:30:00	SPY	ETF	423.52	423.65	423.23	423.51	1501857.0
2021-06-16 13:00:00	SPY	ETF	423.515	423.62	423.0	423.11	1707696.0
2021-06-16 13:30:00	SPY	ETF	423.1	423.48	422.6	423.135	2407198.0
2021-06-16 14:00:00	SPY	ETF	423.13	423.13	419.92	421.545	13924397.0
2021-06-16 14:30:00	SPY	ETF	421.545	421.89	419.94	421.6611	8951671.0
2021-06-16 15:00:00	SPY	ETF	421.67	423.59	421.41	422.93	6776486.0
2021-06-16 15:30:00	SPY	ETF	422.93	423.58	421.93	422.12	10042371.0
2021-06-16 16:00:00	SPY	ETF	422.13	422.45	422.04	422.08	2923457.0
2021-06-16 16:30:00	SPY	ETF	422.05	422.11	420.94	421.01	257558.0
2021-06-16 17:00:00	SPY	ETF	421.0	421.11	420.91	421.01	133371.0
2021-06-16 17:30:00	SPY	ETF	421.0	421.15	420.95	421.14	106737.0
2021-06-16 18:00:00	SPY	ETF	421.15	421.18	420.8	421.0	66102.0
2021-06-16 18:30:00	SPY	ETF	422.11	422.11	420.86	420.98	42072.0
2021-06-16 19:00:00	SPY	ETF	420.9	421.0	420.72	420.78	33453.0
2021-06-16 19:30:00	SPY	ETF	420.77	420.8	420.0	420.35	49362.0
2021-06-16 04:00:00	QQQ	ETF	342.42	342.42	342.18	342.18	22376.0
2021-06-16 04:30:00	QQQ	ETF	342.17	342.45	342.17	342.41	11731.0
2021-06-16 05:00:00	QQQ	ETF	342.45	342.49	342.14	342.14	12518.0
2021-06-16 05:30:00	QQQ	ETF	342.24	342.39	342.23	342.33	2100.0
2021-06-16 06:00:00	QQQ	ETF	342.39	342.59	342.33	342.58	20662.0
2021-06-16 06:30:00	QQQ	ETF	342.63	342.63	342.38	342.4	13552.0
2021-06-16 07:00:00	QQQ	ETF	342.38	342.58	342.26	342.35	31739.0
2021-06-16 07:30:00	QQQ	ETF	342.44	342.47	342.24	342.26	26105.0
2021-06-16 08:00:00	QQQ	ETF	342.5704	342.6096	342.0	342.46	82325.0
2021-06-16 08:30:00	QQQ	ETF	342.54	342.6	342.47	342.58	25984.0
2021-06-16 09:00:00	QQQ	ETF	342.58	342.88	342.54	342.75	55948.0
2021-06-16 09:30:00	QQQ	ETF	342.74	343.65	342.58	343.46	2591823.0
2021-06-16 10:00:00	QQQ	ETF	343.48	343.84	343.26	343.52	1332924.0
2021-06-16 10:30:00	QQQ	ETF	343.52	343.55	342.715	342.99	1644306.0
2021-06-16 11:00:00	QQQ	ETF	342.99	343.06	342.57	342.75	1358096.0
2021-06-16 11:30:00	QQQ	ETF	342.74	342.81	342.11	342.17	1052778.0
2021-06-16 12:00:00	QQQ	ETF	342.16	342.6208	340.96	341.37	1821640.0
2021-06-16 12:30:00	QQQ	ETF	341.36	341.99	341.34	341.9582	1033052.0

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

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