PREVIEW / etf_30min / 2021-08-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-19.parquet
  size:    629 KB
  rows:    24,143

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-08-19 04:00:00	SPY	ETF	437.88	437.88	434.92	435.16	248496.0
2021-08-19 04:30:00	SPY	ETF	435.2	435.6	434.92	435.16	46786.0
2021-08-19 05:00:00	SPY	ETF	435.2	435.35	434.5	435.25	30772.0
2021-08-19 05:30:00	SPY	ETF	435.19	436.75	435.14	436.5	35826.0
2021-08-19 06:00:00	SPY	ETF	436.63	437.02	436.25	436.44	28409.0
2021-08-19 06:30:00	SPY	ETF	436.57	436.68	435.7	435.73	351309.0
2021-08-19 07:00:00	SPY	ETF	435.7	435.98	435.18	435.69	304575.0
2021-08-19 07:30:00	SPY	ETF	435.73	436.1	435.2	435.23	302146.0
2021-08-19 08:00:00	SPY	ETF	435.23	439.07	434.86	435.89	334342.0
2021-08-19 08:30:00	SPY	ETF	435.91	436.07	435.28	435.29	253336.0
2021-08-19 09:00:00	SPY	ETF	435.25	436.77	435.25	436.27	727321.0
2021-08-19 09:30:00	SPY	ETF	436.27	438.87	436.12	438.53	12428529.0
2021-08-19 10:00:00	SPY	ETF	438.53	439.99	438.41	439.07	6825389.0
2021-08-19 10:30:00	SPY	ETF	439.07	439.54	437.5	439.505	7301833.0
2021-08-19 11:00:00	SPY	ETF	439.51	439.66	438.82	438.92	4736016.0
2021-08-19 11:30:00	SPY	ETF	438.94	441.06	438.91	440.725	4341205.0
2021-08-19 12:00:00	SPY	ETF	440.725	441.14	439.975	440.225	3240748.0
2021-08-19 12:30:00	SPY	ETF	440.221	440.95	440.1	440.88	2382988.0
2021-08-19 13:00:00	SPY	ETF	440.89	440.935	439.4376	439.44	3135026.0
2021-08-19 13:30:00	SPY	ETF	439.445	440.07	438.92	438.92	3472332.0
2021-08-19 14:00:00	SPY	ETF	438.92	439.36	438.09	438.14	4886712.0
2021-08-19 14:30:00	SPY	ETF	438.14	439.73	437.46	439.64	7141206.0
2021-08-19 15:00:00	SPY	ETF	439.64	440.96	439.6	440.8901	4789474.0
2021-08-19 15:30:00	SPY	ETF	440.895	441.0599	439.25	439.84	10176787.0
2021-08-19 16:00:00	SPY	ETF	439.83	440.4	439.8	439.95	2913029.0
2021-08-19 16:30:00	SPY	ETF	439.9	440.02	439.83	439.95	159995.0
2021-08-19 17:00:00	SPY	ETF	440.02	440.02	439.94	440.0	10627.0
2021-08-19 17:30:00	SPY	ETF	440.03	440.03	439.8	439.87	77345.0
2021-08-19 18:00:00	SPY	ETF	439.89	439.96	439.67	439.91	143668.0
2021-08-19 18:30:00	SPY	ETF	439.86	439.96	439.57	439.62	10531.0
2021-08-19 19:00:00	SPY	ETF	439.65	439.69	439.54	439.68	6940.0
2021-08-19 19:30:00	SPY	ETF	439.64	439.64	438.94	439.12	150389.0
2021-08-19 04:00:00	QQQ	ETF	360.96	360.96	358.67	358.76	74900.0
2021-08-19 04:30:00	QQQ	ETF	358.81	359.33	358.81	359.11	44271.0
2021-08-19 05:00:00	QQQ	ETF	359.19	359.34	358.76	359.34	36739.0
2021-08-19 05:30:00	QQQ	ETF	359.31	360.54	359.26	360.39	72785.0
2021-08-19 06:00:00	QQQ	ETF	360.52	360.78	360.14	360.36	59383.0
2021-08-19 06:30:00	QQQ	ETF	360.47	360.47	359.75	359.83	161148.0
2021-08-19 07:00:00	QQQ	ETF	359.8	360.03	359.41	359.77	142404.0
2021-08-19 07:30:00	QQQ	ETF	359.81	360.09	359.42	359.46	138585.0
2021-08-19 08:00:00	QQQ	ETF	360.6904	362.11	359.23	359.94	319801.0
2021-08-19 08:30:00	QQQ	ETF	359.878	360.11	359.38	359.38	214342.0
2021-08-19 09:00:00	QQQ	ETF	359.37	360.55	359.37	360.22	266248.0
2021-08-19 09:30:00	QQQ	ETF	360.22	361.7001	359.96	360.9	5928846.0
2021-08-19 10:00:00	QQQ	ETF	360.9	362.94	360.86	362.48	2855943.0
2021-08-19 10:30:00	QQQ	ETF	362.5	363.27	361.43	363.21	2619106.0
2021-08-19 11:00:00	QQQ	ETF	363.22	364.27	362.95	363.59	2622688.0
2021-08-19 11:30:00	QQQ	ETF	363.61	365.44	363.61	365.23	2617638.0
2021-08-19 12:00:00	QQQ	ETF	365.24	365.68	364.54	364.79	1900275.0
2021-08-19 12:30:00	QQQ	ETF	364.759	365.52	364.75	365.4099	1130969.0

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

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