PREVIEW / etf_30min / 2021-04-07

all etf 30-min files

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

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-04-07 04:00:00	SPY	ETF	406.73	406.73	406.16	406.35	18606.0
2021-04-07 04:30:00	SPY	ETF	406.38	406.38	406.26	406.26	2781.0
2021-04-07 05:00:00	SPY	ETF	406.37	406.45	406.04	406.19	5981.0
2021-04-07 05:30:00	SPY	ETF	406.03	406.16	405.9	406.08	5290.0
2021-04-07 06:00:00	SPY	ETF	406.21	406.41	406.21	406.29	8000.0
2021-04-07 06:30:00	SPY	ETF	406.17	406.37	406.13	406.22	14807.0
2021-04-07 07:00:00	SPY	ETF	406.15	406.27	406.0	406.0	47832.0
2021-04-07 07:30:00	SPY	ETF	406.029	406.19	405.93	405.93	63906.0
2021-04-07 08:00:00	SPY	ETF	406.2401	406.3196	405.6	405.73	131020.0
2021-04-07 08:30:00	SPY	ETF	405.68	405.75	405.3	405.31	103277.0
2021-04-07 09:00:00	SPY	ETF	405.35	406.0	405.35	405.94	614190.0
2021-04-07 09:30:00	SPY	ETF	405.94	406.61	405.93	406.299	4108278.0
2021-04-07 10:00:00	SPY	ETF	406.29	406.86	406.05	406.86	3019875.0
2021-04-07 10:30:00	SPY	ETF	406.86	406.96	406.62	406.68	2293824.0
2021-04-07 11:00:00	SPY	ETF	406.675	406.93	406.17	406.24	2340823.0
2021-04-07 11:30:00	SPY	ETF	406.25	406.28	405.61	406.08	3257508.0
2021-04-07 12:00:00	SPY	ETF	406.07	406.31	405.5	405.51	3543244.0
2021-04-07 12:30:00	SPY	ETF	405.51	406.26	405.45	406.07	2593956.0
2021-04-07 13:00:00	SPY	ETF	406.07	406.31	405.88	406.05	1499508.0
2021-04-07 13:30:00	SPY	ETF	406.043	406.52	405.98	406.39	1789596.0
2021-04-07 14:00:00	SPY	ETF	406.39	406.91	406.33	406.62	2997640.0
2021-04-07 14:30:00	SPY	ETF	406.62	406.8	406.3901	406.4219	1889986.0
2021-04-07 15:00:00	SPY	ETF	406.43	406.77	405.87	406.055	3214835.0
2021-04-07 15:30:00	SPY	ETF	406.05	406.75	405.76	406.58	7997625.0
2021-04-07 16:00:00	SPY	ETF	406.57	407.0	406.55	406.89	1840901.0
2021-04-07 16:30:00	SPY	ETF	406.89	407.15	406.59	407.11	435050.0
2021-04-07 17:00:00	SPY	ETF	407.12	407.12	407.03	407.04	57504.0
2021-04-07 17:30:00	SPY	ETF	407.01	407.12	407.01	407.1	20224.0
2021-04-07 18:00:00	SPY	ETF	407.07	407.17	406.98	407.0	83449.0
2021-04-07 18:30:00	SPY	ETF	406.59	407.12	406.59	407.05	18067.0
2021-04-07 19:00:00	SPY	ETF	406.98	407.05	406.9	406.92	17253.0
2021-04-07 19:30:00	SPY	ETF	406.96	407.9	406.96	407.64	100521.0
2021-04-07 04:00:00	QQQ	ETF	331.35	331.41	330.96	331.16	7290.0
2021-04-07 04:30:00	QQQ	ETF	331.11	331.21	331.05	331.05	3450.0
2021-04-07 05:00:00	QQQ	ETF	331.03	331.13	330.71	330.93	9988.0
2021-04-07 05:30:00	QQQ	ETF	330.9	330.9	330.5	330.87	14500.0
2021-04-07 06:00:00	QQQ	ETF	330.84	331.4	330.84	331.14	29929.0
2021-04-07 06:30:00	QQQ	ETF	331.16	331.16	330.82	330.92	17923.0
2021-04-07 07:00:00	QQQ	ETF	330.89	331.05	330.56	330.56	50437.0
2021-04-07 07:30:00	QQQ	ETF	330.57	330.94	330.57	330.64	42383.0
2021-04-07 08:00:00	QQQ	ETF	330.9896	331.6	330.33	330.56	108066.0
2021-04-07 08:30:00	QQQ	ETF	330.51	330.64	329.82	329.82	170129.0
2021-04-07 09:00:00	QQQ	ETF	329.8	330.52	329.8	330.35	200745.0
2021-04-07 09:30:00	QQQ	ETF	330.33	331.12	329.37	330.915	3437896.0
2021-04-07 10:00:00	QQQ	ETF	330.93	331.92	330.68	331.91	2290554.0
2021-04-07 10:30:00	QQQ	ETF	331.91	331.9999	331.3	331.53	1244253.0
2021-04-07 11:00:00	QQQ	ETF	331.54	332.245	331.31	331.3725	1571405.0
2021-04-07 11:30:00	QQQ	ETF	331.38	331.54	330.61	331.4718	1887104.0
2021-04-07 12:00:00	QQQ	ETF	331.46	331.7399	330.67	330.69	1344213.0
2021-04-07 12:30:00	QQQ	ETF	330.69	331.31	330.551	330.8833	1046992.0

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

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