PREVIEW / etf_30min / 2021-05-07

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-07.parquet
  size:    613 KB
  rows:    23,477

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-05-07 04:00:00	SPY	ETF	419.13	419.38	419.1	419.34	4123.0
2021-05-07 04:30:00	SPY	ETF	419.45	419.59	419.44	419.5	13139.0
2021-05-07 05:00:00	SPY	ETF	419.59	419.64	419.49	419.63	2538.0
2021-05-07 05:30:00	SPY	ETF	419.64	419.71	419.63	419.64	2125.0
2021-05-07 06:00:00	SPY	ETF	419.97	420.24	419.89	420.19	11184.0
2021-05-07 06:30:00	SPY	ETF	420.13	420.25	420.05	420.05	6399.0
2021-05-07 07:00:00	SPY	ETF	420.09	420.11	419.81	419.89	68966.0
2021-05-07 07:30:00	SPY	ETF	419.92	420.13	419.9	420.13	67225.0
2021-05-07 08:00:00	SPY	ETF	420.1	420.5	419.0	420.3	172000.0
2021-05-07 08:30:00	SPY	ETF	420.37	421.5	419.28	420.38	1494991.0
2021-05-07 09:00:00	SPY	ETF	420.4	420.7	419.83	419.89	488796.0
2021-05-07 09:30:00	SPY	ETF	419.89	421.48	419.16	420.95	7892075.0
2021-05-07 10:00:00	SPY	ETF	420.96	422.67	420.88	422.135	5841828.0
2021-05-07 10:30:00	SPY	ETF	422.14	422.46	421.77	422.1719	2948032.0
2021-05-07 11:00:00	SPY	ETF	422.17	422.5999	422.05	422.33	2160656.0
2021-05-07 11:30:00	SPY	ETF	422.34	422.815	422.29	422.535	2744275.0
2021-05-07 12:00:00	SPY	ETF	422.54	422.57	421.9686	422.0299	2202069.0
2021-05-07 12:30:00	SPY	ETF	422.03	422.26	421.64	422.105	2308068.0
2021-05-07 13:00:00	SPY	ETF	422.11	422.15	421.45	421.495	2116133.0
2021-05-07 13:30:00	SPY	ETF	421.4919	422.04	421.49	421.695	1827955.0
2021-05-07 14:00:00	SPY	ETF	421.6919	422.285	421.21	422.265	2609916.0
2021-05-07 14:30:00	SPY	ETF	422.2601	422.29	421.61	422.1481	2388261.0
2021-05-07 15:00:00	SPY	ETF	422.145	422.79	421.97	422.55	3754994.0
2021-05-07 15:30:00	SPY	ETF	422.56	422.79	422.01	422.09	9051658.0
2021-05-07 16:00:00	SPY	ETF	422.08	422.54	422.04	422.33	2650856.0
2021-05-07 16:30:00	SPY	ETF	422.33	422.45	422.28	422.3	284832.0
2021-05-07 17:00:00	SPY	ETF	422.3	422.5	422.25	422.5	25026.0
2021-05-07 17:30:00	SPY	ETF	422.5	422.6	422.5	422.52	27283.0
2021-05-07 18:00:00	SPY	ETF	422.52	422.62	422.46	422.46	16531.0
2021-05-07 18:30:00	SPY	ETF	422.12	422.49	422.12	422.4	16899.0
2021-05-07 19:00:00	SPY	ETF	422.4	422.49	422.32	422.4	13706.0
2021-05-07 19:30:00	SPY	ETF	422.4	422.6	422.4	422.42	11933.0
2021-05-07 04:00:00	QQQ	ETF	331.73	332.0	331.58	332.0	12273.0
2021-05-07 04:30:00	QQQ	ETF	331.97	332.14	331.95	332.14	8194.0
2021-05-07 05:00:00	QQQ	ETF	332.18	332.33	331.9	332.33	22868.0
2021-05-07 05:30:00	QQQ	ETF	332.32	332.36	332.17	332.36	9473.0
2021-05-07 06:00:00	QQQ	ETF	332.52	332.6	332.31	332.31	15926.0
2021-05-07 06:30:00	QQQ	ETF	332.32	332.8	332.3	332.57	31380.0
2021-05-07 07:00:00	QQQ	ETF	332.56	332.65	332.27	332.381	55322.0
2021-05-07 07:30:00	QQQ	ETF	332.391	332.55	332.26	332.36	58314.0
2021-05-07 08:00:00	QQQ	ETF	332.37	332.7796	331.54	332.57	217313.0
2021-05-07 08:30:00	QQQ	ETF	332.6	336.86	332.36	335.67	3407290.0
2021-05-07 09:00:00	QQQ	ETF	335.7	336.06	334.3	334.38	899110.0
2021-05-07 09:30:00	QQQ	ETF	334.39	335.32	333.1	334.55	8166254.0
2021-05-07 10:00:00	QQQ	ETF	334.57	336.65	333.97	335.89	5164321.0
2021-05-07 10:30:00	QQQ	ETF	335.89	336.43	335.13	335.72	3174810.0
2021-05-07 11:00:00	QQQ	ETF	335.71	336.33	335.57	336.25	2265235.0
2021-05-07 11:30:00	QQQ	ETF	336.26	336.43	335.73	336.16	1656537.0
2021-05-07 12:00:00	QQQ	ETF	336.16	336.19	334.96	335.05	1515382.0
2021-05-07 12:30:00	QQQ	ETF	335.03	335.17	334.44	334.94	1789287.0

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

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