PREVIEW / etf_30min / 2020-10-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-21.parquet
  size:    547 KB
  rows:    20,184

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-10-21 04:00:00	SPY	ETF	343.93	343.97	342.5	342.86	40748.0
2020-10-21 04:30:00	SPY	ETF	342.83	343.24	342.22	342.24	31541.0
2020-10-21 05:00:00	SPY	ETF	342.23	343.14	342.05	343.14	32650.0
2020-10-21 05:30:00	SPY	ETF	343.17	343.75	342.97	343.54	34173.0
2020-10-21 06:00:00	SPY	ETF	343.64	343.69	343.09	343.43	42225.0
2020-10-21 06:30:00	SPY	ETF	343.38	343.7	343.38	343.38	4647.0
2020-10-21 07:00:00	SPY	ETF	343.35	343.35	342.31	342.6	60142.0
2020-10-21 07:30:00	SPY	ETF	342.65	343.07	342.48	342.85	70262.0
2020-10-21 08:00:00	SPY	ETF	342.92	345.33	342.52	343.57	247044.0
2020-10-21 08:30:00	SPY	ETF	343.5099	343.87	343.43	343.432	195298.0
2020-10-21 09:00:00	SPY	ETF	343.41	343.67	343.26	343.34	299896.0
2020-10-21 09:30:00	SPY	ETF	343.33	345.5319	343.11	345.39	4597550.0
2020-10-21 10:00:00	SPY	ETF	345.405	345.67	344.91	345.01	3168249.0
2020-10-21 10:30:00	SPY	ETF	345.01	345.14	343.8546	344.05	2492506.0
2020-10-21 11:00:00	SPY	ETF	344.05	344.13	342.4	343.17	4400956.0
2020-10-21 11:30:00	SPY	ETF	343.17	344.0543	342.86	343.133	3909837.0
2020-10-21 12:00:00	SPY	ETF	343.16	345.1	342.79	343.89	5849972.0
2020-10-21 12:30:00	SPY	ETF	343.91	344.021	342.45	342.775	4300940.0
2020-10-21 13:00:00	SPY	ETF	342.77	343.7	342.63	343.6	2955032.0
2020-10-21 13:30:00	SPY	ETF	343.6	344.2	343.11	343.53	3033354.0
2020-10-21 14:00:00	SPY	ETF	343.53	344.67	343.33	344.4	3175015.0
2020-10-21 14:30:00	SPY	ETF	344.41	344.94	344.25	344.91	2476702.0
2020-10-21 15:00:00	SPY	ETF	344.92	345.02	343.77	344.565	3297694.0
2020-10-21 15:30:00	SPY	ETF	344.58	344.75	342.61	342.69	11608785.0
2020-10-21 16:00:00	SPY	ETF	342.65	343.77	342.61	343.23	5342671.0
2020-10-21 16:30:00	SPY	ETF	343.23	343.44	342.95	343.07	302747.0
2020-10-21 17:00:00	SPY	ETF	343.09	343.29	343.06	343.12	98609.0
2020-10-21 17:30:00	SPY	ETF	343.12	343.23	342.5	342.99	190828.0
2020-10-21 18:00:00	SPY	ETF	342.85	343.26	342.69	343.24	158764.0
2020-10-21 18:30:00	SPY	ETF	343.24	343.3	342.72	342.73	45249.0
2020-10-21 19:00:00	SPY	ETF	342.79	343.14	342.4	342.5699	84086.0
2020-10-21 19:30:00	SPY	ETF	342.63	342.67	340.28	341.34	323270.0
2020-10-21 04:00:00	QQQ	ETF	284.7	284.95	283.43	283.68	53381.0
2020-10-21 04:30:00	QQQ	ETF	283.63	284.17	283.12	283.12	23137.0
2020-10-21 05:00:00	QQQ	ETF	283.07	284.35	282.73	284.28	49679.0
2020-10-21 05:30:00	QQQ	ETF	284.35	285.04	284.18	284.68	39658.0
2020-10-21 06:00:00	QQQ	ETF	284.88	285.02	284.3	285.02	34749.0
2020-10-21 06:30:00	QQQ	ETF	285.0	285.13	284.74	284.8	12441.0
2020-10-21 07:00:00	QQQ	ETF	284.82	284.83	283.64	283.75	73007.0
2020-10-21 07:30:00	QQQ	ETF	283.75	283.92	283.43	283.63	59817.0
2020-10-21 08:00:00	QQQ	ETF	284.17	286.32	283.45	284.51	89372.0
2020-10-21 08:30:00	QQQ	ETF	284.48	284.9	284.42	284.78	96145.0
2020-10-21 09:00:00	QQQ	ETF	284.79	284.91	284.43	284.62	127270.0
2020-10-21 09:30:00	QQQ	ETF	284.67	287.32	284.34	287.19	2582891.0
2020-10-21 10:00:00	QQQ	ETF	287.19	287.3199	286.16	286.485	1884028.0
2020-10-21 10:30:00	QQQ	ETF	286.48	286.67	285.22	285.44	1844118.0
2020-10-21 11:00:00	QQQ	ETF	285.44	285.66	283.69	284.63	2093243.0
2020-10-21 11:30:00	QQQ	ETF	284.64	285.61	284.2	284.49	1480174.0
2020-10-21 12:00:00	QQQ	ETF	284.525	286.31	284.0	285.31	2226110.0
2020-10-21 12:30:00	QQQ	ETF	285.31	285.45	283.76	284.01	1595520.0

> showing 50 of 20,184 rows — these rows as CSV

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