PREVIEW / etf_30min / 2020-12-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-02.parquet
  size:    584 KB
  rows:    22,005

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-02 04:00:00	SPY	ETF	365.22	365.59	365.06	365.5	3214.0
2020-12-02 04:30:00	SPY	ETF	365.52	365.52	365.34	365.38	1913.0
2020-12-02 05:00:00	SPY	ETF	365.43	365.51	365.39	365.39	5063.0
2020-12-02 05:30:00	SPY	ETF	365.44	365.57	365.32	365.57	19253.0
2020-12-02 06:00:00	SPY	ETF	365.43	365.43	365.0	365.15	34346.0
2020-12-02 06:30:00	SPY	ETF	365.03	365.44	365.03	365.44	4793.0
2020-12-02 07:00:00	SPY	ETF	365.33	365.42	364.91	364.91	259426.0
2020-12-02 07:30:00	SPY	ETF	364.94	364.97	364.3	364.83	184211.0
2020-12-02 08:00:00	SPY	ETF	364.7	365.3804	364.27	364.8	115855.0
2020-12-02 08:30:00	SPY	ETF	364.83	364.94	364.66	364.91	249584.0
2020-12-02 09:00:00	SPY	ETF	364.9	365.01	364.4999	364.83	317147.0
2020-12-02 09:30:00	SPY	ETF	364.82	365.505	364.2	365.41	5432233.0
2020-12-02 10:00:00	SPY	ETF	365.41	365.748	364.96	365.66	3009131.0
2020-12-02 10:30:00	SPY	ETF	365.66	365.9	365.34	365.68	3209564.0
2020-12-02 11:00:00	SPY	ETF	365.7	366.17	365.69	366.03	2579584.0
2020-12-02 11:30:00	SPY	ETF	366.035	366.41	365.87	366.23	1436504.0
2020-12-02 12:00:00	SPY	ETF	366.2311	366.32	365.92	366.155	1309021.0
2020-12-02 12:30:00	SPY	ETF	366.16	366.46	365.94	366.0744	2947838.0
2020-12-02 13:00:00	SPY	ETF	366.08	366.36	365.92	366.0799	1298356.0
2020-12-02 13:30:00	SPY	ETF	366.075	366.18	365.64	365.69	1841801.0
2020-12-02 14:00:00	SPY	ETF	365.7	366.51	365.49	366.41	2662962.0
2020-12-02 14:30:00	SPY	ETF	366.41	366.85	366.34	366.77	2600330.0
2020-12-02 15:00:00	SPY	ETF	366.75	366.89	366.23	366.36	3001429.0
2020-12-02 15:30:00	SPY	ETF	366.36	366.96	366.26	366.7599	5641843.0
2020-12-02 16:00:00	SPY	ETF	366.75	367.21	366.64	366.93	4315153.0
2020-12-02 16:30:00	SPY	ETF	366.95	367.11	366.79	366.96	1502687.0
2020-12-02 17:00:00	SPY	ETF	366.93	367.01	366.93	366.95	528495.0
2020-12-02 17:30:00	SPY	ETF	366.91	367.02	366.89	366.97	14104.0
2020-12-02 18:00:00	SPY	ETF	367.02	367.27	366.7	366.81	79415.0
2020-12-02 18:30:00	SPY	ETF	366.81	366.86	366.6	366.68	23156.0
2020-12-02 19:00:00	SPY	ETF	366.61	366.7	366.41	366.47	50240.0
2020-12-02 19:30:00	SPY	ETF	366.5	366.63	366.4	366.5	42947.0
2020-12-02 04:00:00	QQQ	ETF	303.52	303.61	303.41	303.56	14715.0
2020-12-02 04:30:00	QQQ	ETF	303.58	303.59	303.34	303.47	2367.0
2020-12-02 05:00:00	QQQ	ETF	303.47	303.58	303.32	303.35	3275.0
2020-12-02 05:30:00	QQQ	ETF	303.39	303.52	303.23	303.5	4117.0
2020-12-02 06:00:00	QQQ	ETF	303.55	303.56	303.1	303.1	36455.0
2020-12-02 06:30:00	QQQ	ETF	303.06	303.35	303.03	303.33	32046.0
2020-12-02 07:00:00	QQQ	ETF	303.33	303.37	302.75	302.8	58291.0
2020-12-02 07:30:00	QQQ	ETF	302.75	302.8	302.27	302.61	58543.0
2020-12-02 08:00:00	QQQ	ETF	303.2796	303.46	302.2998	302.54	88509.0
2020-12-02 08:30:00	QQQ	ETF	302.48	302.55	302.28	302.55	47216.0
2020-12-02 09:00:00	QQQ	ETF	302.48	302.51	301.75	302.2	127131.0
2020-12-02 09:30:00	QQQ	ETF	302.21	302.36	300.35	301.82	3817721.0
2020-12-02 10:00:00	QQQ	ETF	301.83	303.15	301.55	302.86	2141609.0
2020-12-02 10:30:00	QQQ	ETF	302.85	303.33	302.42	302.74	1351914.0
2020-12-02 11:00:00	QQQ	ETF	302.75	303.46	302.75	303.3201	908510.0
2020-12-02 11:30:00	QQQ	ETF	303.35	303.9	302.98	303.86	1018253.0
2020-12-02 12:00:00	QQQ	ETF	303.8544	304.195	303.47	303.79	970974.0
2020-12-02 12:30:00	QQQ	ETF	303.79	303.858	303.18	303.3245	1420496.0

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

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