PREVIEW / etf_30min / 2021-07-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-19.parquet
  size:    662 KB
  rows:    26,105

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-07-19 04:00:00	SPY	ETF	429.28	429.97	429.28	429.52	27500.0
2021-07-19 04:30:00	SPY	ETF	429.41	429.41	428.09	428.25	30961.0
2021-07-19 05:00:00	SPY	ETF	428.13	428.64	428.13	428.38	49700.0
2021-07-19 05:30:00	SPY	ETF	428.26	428.86	428.15	428.7	17696.0
2021-07-19 06:00:00	SPY	ETF	428.8	428.8	427.92	428.27	27612.0
2021-07-19 06:30:00	SPY	ETF	428.32	428.42	427.9	428.07	41989.0
2021-07-19 07:00:00	SPY	ETF	428.11	428.34	427.2	427.2	182678.0
2021-07-19 07:30:00	SPY	ETF	427.18	427.18	426.26	426.96	560215.0
2021-07-19 08:00:00	SPY	ETF	426.98	430.3	425.89	426.29	644527.0
2021-07-19 08:30:00	SPY	ETF	426.23	426.82	425.99	426.45	1056970.0
2021-07-19 09:00:00	SPY	ETF	426.42	426.45	425.8	426.17	526165.0
2021-07-19 09:30:00	SPY	ETF	426.19	426.71	423.95	424.27	14670859.0
2021-07-19 10:00:00	SPY	ETF	424.25	424.42	422.665	423.975	12139021.0
2021-07-19 10:30:00	SPY	ETF	423.97	424.59	423.01	424.1119	7525579.0
2021-07-19 11:00:00	SPY	ETF	424.12	425.18	423.58	424.3319	6825432.0
2021-07-19 11:30:00	SPY	ETF	424.34	425.38	424.195	424.925	5259000.0
2021-07-19 12:00:00	SPY	ETF	424.92	424.92	423.38	423.45	5071240.0
2021-07-19 12:30:00	SPY	ETF	423.44	423.51	422.26	422.855	6577641.0
2021-07-19 13:00:00	SPY	ETF	422.84	423.46	422.295	422.44	5839809.0
2021-07-19 13:30:00	SPY	ETF	422.435	422.88	421.97	422.135	5463939.0
2021-07-19 14:00:00	SPY	ETF	422.13	423.41	422.1	423.2801	5622922.0
2021-07-19 14:30:00	SPY	ETF	423.27	423.35	421.97	422.3999	6154550.0
2021-07-19 15:00:00	SPY	ETF	422.39	423.48	422.185	422.32	8533555.0
2021-07-19 15:30:00	SPY	ETF	422.33	425.01	422.22	424.96	19848623.0
2021-07-19 16:00:00	SPY	ETF	424.96	425.34	423.9397	425.14	6061629.0
2021-07-19 16:30:00	SPY	ETF	425.14	426.0	424.57	425.57	584112.0
2021-07-19 17:00:00	SPY	ETF	425.47	425.67	425.45	425.54	150932.0
2021-07-19 17:30:00	SPY	ETF	425.54	425.7	425.54	425.69	45191.0
2021-07-19 18:00:00	SPY	ETF	425.75	425.79	425.35	425.35	58314.0
2021-07-19 18:30:00	SPY	ETF	425.39	425.6	425.32	425.6	42364.0
2021-07-19 19:00:00	SPY	ETF	425.65	425.86	425.46	425.53	105357.0
2021-07-19 19:30:00	SPY	ETF	425.53	425.94	425.53	425.75	145013.0
2021-07-19 04:00:00	QQQ	ETF	357.14	357.4	356.99	357.08	58032.0
2021-07-19 04:30:00	QQQ	ETF	357.1	357.1	355.94	356.12	56136.0
2021-07-19 05:00:00	QQQ	ETF	356.01	356.33	355.95	356.0	116170.0
2021-07-19 05:30:00	QQQ	ETF	355.96	356.6	355.82	356.39	29334.0
2021-07-19 06:00:00	QQQ	ETF	356.53	356.69	356.0	356.38	104512.0
2021-07-19 06:30:00	QQQ	ETF	356.35	356.38	356.02	356.23	30911.0
2021-07-19 07:00:00	QQQ	ETF	356.26	356.32	354.7	354.7	279003.0
2021-07-19 07:30:00	QQQ	ETF	354.7	354.77	353.96	354.59	316398.0
2021-07-19 08:00:00	QQQ	ETF	356.1604	357.868	353.47	354.1	334967.0
2021-07-19 08:30:00	QQQ	ETF	354.08	354.59	353.92	354.38	433268.0
2021-07-19 09:00:00	QQQ	ETF	354.3	354.41	353.96	354.03	299915.0
2021-07-19 09:30:00	QQQ	ETF	354.05	355.15	352.67	352.96	7852912.0
2021-07-19 10:00:00	QQQ	ETF	352.96	353.69	352.33	353.59	5552884.0
2021-07-19 10:30:00	QQQ	ETF	353.59	353.81	352.04	353.77	3861148.0
2021-07-19 11:00:00	QQQ	ETF	353.8	354.89	353.41	354.1601	3201392.0
2021-07-19 11:30:00	QQQ	ETF	354.18	355.18	354.08	354.2475	2884767.0
2021-07-19 12:00:00	QQQ	ETF	354.25	354.31	353.29	353.67	2232388.0
2021-07-19 12:30:00	QQQ	ETF	353.65	353.67	352.32	352.75	2572157.0

> showing 50 of 26,105 rows — these rows as CSV

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