PREVIEW / etf_30min / 2020-12-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-30.parquet
  size:    592 KB
  rows:    22,312

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
2020-12-30 04:00:00	SPY	ETF	372.72	372.72	372.57	372.71	7657.0
2020-12-30 04:30:00	SPY	ETF	372.64	372.71	372.64	372.71	600.0
2020-12-30 05:00:00	SPY	ETF	372.7	372.9	372.7	372.9	5418.0
2020-12-30 05:30:00	SPY	ETF	372.93	373.0	372.85	373.0	23088.0
2020-12-30 06:00:00	SPY	ETF	372.95	372.98	372.5	372.66	5040.0
2020-12-30 06:30:00	SPY	ETF	372.64	372.79	372.59	372.71	60173.0
2020-12-30 07:00:00	SPY	ETF	372.7	372.77	372.52	372.6	22184.0
2020-12-30 07:30:00	SPY	ETF	372.56	372.68	372.37	372.62	75143.0
2020-12-30 08:00:00	SPY	ETF	372.63	373.01	372.38	372.67	54102.0
2020-12-30 08:30:00	SPY	ETF	372.7	372.71	372.2	372.21	78820.0
2020-12-30 09:00:00	SPY	ETF	372.21	372.41	372.01	372.36	96406.0
2020-12-30 09:30:00	SPY	ETF	372.34	372.879	372.25	372.79	3759267.0
2020-12-30 10:00:00	SPY	ETF	372.79	373.1	372.2501	372.7281	3270410.0
2020-12-30 10:30:00	SPY	ETF	372.73	372.9899	372.21	372.6554	3592835.0
2020-12-30 11:00:00	SPY	ETF	372.64	372.79	372.3982	372.43	2616507.0
2020-12-30 11:30:00	SPY	ETF	372.43	372.655	372.22	372.4799	1366642.0
2020-12-30 12:00:00	SPY	ETF	372.48	372.62	372.36	372.515	1036585.0
2020-12-30 12:30:00	SPY	ETF	372.525	372.53	372.12	372.28	1366684.0
2020-12-30 13:00:00	SPY	ETF	372.2801	372.55	372.2389	372.2389	1397073.0
2020-12-30 13:30:00	SPY	ETF	372.2234	372.45	372.11	372.24	998341.0
2020-12-30 14:00:00	SPY	ETF	372.23	372.3	371.81	371.92	1640904.0
2020-12-30 14:30:00	SPY	ETF	371.92	372.05	371.67	371.78	2033879.0
2020-12-30 15:00:00	SPY	ETF	371.77	371.87	371.57	371.79	1859657.0
2020-12-30 15:30:00	SPY	ETF	371.79	372.44	371.69	371.93	13254677.0
2020-12-30 16:00:00	SPY	ETF	371.92	373.0	371.54	371.74	7330936.0
2020-12-30 16:30:00	SPY	ETF	371.74	371.99	371.71	371.9	192995.0
2020-12-30 17:00:00	SPY	ETF	371.88	372.0	371.88	371.99	30603.0
2020-12-30 17:30:00	SPY	ETF	371.98	372.01	371.86	371.92	17695.0
2020-12-30 18:00:00	SPY	ETF	371.99	372.21	371.93	372.14	47069.0
2020-12-30 18:30:00	SPY	ETF	372.05	372.19	372.04	372.12	8785.0
2020-12-30 19:00:00	SPY	ETF	372.1	372.29	372.1	372.26	7174.0
2020-12-30 19:30:00	SPY	ETF	372.25	372.3	372.2	372.27	20220.0
2020-12-30 04:00:00	QQQ	ETF	313.82	313.86	313.72	313.84	14784.0
2020-12-30 04:30:00	QQQ	ETF	313.86	313.94	313.86	313.94	3179.0
2020-12-30 05:00:00	QQQ	ETF	313.97	314.05	313.97	314.05	4850.0
2020-12-30 05:30:00	QQQ	ETF	314.0	314.04	313.98	314.01	8917.0
2020-12-30 06:00:00	QQQ	ETF	313.93	313.94	313.65	313.75	7880.0
2020-12-30 06:30:00	QQQ	ETF	313.76	313.89	313.74	313.89	5400.0
2020-12-30 07:00:00	QQQ	ETF	313.9	314.03	313.8	313.86	20147.0
2020-12-30 07:30:00	QQQ	ETF	313.8	314.0	313.74	313.99	16851.0
2020-12-30 08:00:00	QQQ	ETF	313.98	314.19	313.75	314.15	47761.0
2020-12-30 08:30:00	QQQ	ETF	314.13	314.36	314.13	314.19	66828.0
2020-12-30 09:00:00	QQQ	ETF	314.21	314.24	314.02	314.15	84762.0
2020-12-30 09:30:00	QQQ	ETF	314.17	314.49	313.04	313.41	2229043.0
2020-12-30 10:00:00	QQQ	ETF	313.41	313.5	312.68	313.26	1690212.0
2020-12-30 10:30:00	QQQ	ETF	313.27	313.4301	312.33	313.12	1488826.0
2020-12-30 11:00:00	QQQ	ETF	313.13	313.41	312.875	313.2	919221.0
2020-12-30 11:30:00	QQQ	ETF	313.2	313.56	313.03	313.52	727333.0
2020-12-30 12:00:00	QQQ	ETF	313.53	313.59	313.13	313.42	491914.0
2020-12-30 12:30:00	QQQ	ETF	313.4232	313.45	313.02	313.18	351776.0

> showing 50 of 22,312 rows — these rows as CSV

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