PREVIEW / etf_30min / 2020-10-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-14.parquet
  size:    554 KB
  rows:    20,307

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-14 04:00:00	SPY	ETF	351.6	351.93	351.53	351.93	11878.0
2020-10-14 04:30:00	SPY	ETF	351.99	352.28	351.83	351.97	10053.0
2020-10-14 05:00:00	SPY	ETF	351.97	352.02	351.72	351.72	4935.0
2020-10-14 05:30:00	SPY	ETF	351.7	351.74	351.1	351.26	10175.0
2020-10-14 06:00:00	SPY	ETF	351.24	351.42	350.04	350.18	23762.0
2020-10-14 06:30:00	SPY	ETF	350.1	350.1	349.35	349.69	55092.0
2020-10-14 07:00:00	SPY	ETF	349.71	350.38	349.68	350.38	51375.0
2020-10-14 07:30:00	SPY	ETF	350.38	350.45	349.72	350.08	108767.0
2020-10-14 08:00:00	SPY	ETF	350.11	351.94	349.74	350.42	116597.0
2020-10-14 08:30:00	SPY	ETF	350.36	351.16	350.2	351.06	166632.0
2020-10-14 09:00:00	SPY	ETF	351.09	351.09	350.71	350.72	113071.0
2020-10-14 09:30:00	SPY	ETF	350.75	351.93	350.42	351.725	3631588.0
2020-10-14 10:00:00	SPY	ETF	351.73	351.8	350.07	350.17	3102469.0
2020-10-14 10:30:00	SPY	ETF	350.18	350.94	349.78	350.6714	2956478.0
2020-10-14 11:00:00	SPY	ETF	350.68	350.9	349.98	350.07	2655100.0
2020-10-14 11:30:00	SPY	ETF	350.08	350.23	348.04	348.18	5281646.0
2020-10-14 12:00:00	SPY	ETF	348.19	349.02	347.14	347.88	5181250.0
2020-10-14 12:30:00	SPY	ETF	347.88	348.344	347.29	347.99	2554054.0
2020-10-14 13:00:00	SPY	ETF	347.95	348.47	347.64	347.71	2284123.0
2020-10-14 13:30:00	SPY	ETF	347.71	348.25	347.21	348.11	2859741.0
2020-10-14 14:00:00	SPY	ETF	348.106	348.76	347.82	348.07	2586296.0
2020-10-14 14:30:00	SPY	ETF	348.0789	348.3	347.2	348.14	3077943.0
2020-10-14 15:00:00	SPY	ETF	348.14	349.25	347.94	348.69	4358202.0
2020-10-14 15:30:00	SPY	ETF	348.69	349.3	347.785	347.97	8423275.0
2020-10-14 16:00:00	SPY	ETF	347.97	348.21	347.76	347.99	6821694.0
2020-10-14 16:30:00	SPY	ETF	348.01	348.06	347.85	347.91	152148.0
2020-10-14 17:00:00	SPY	ETF	347.96	348.04	347.91	348.04	137058.0
2020-10-14 17:30:00	SPY	ETF	348.02	348.02	347.85	347.95	36906.0
2020-10-14 18:00:00	SPY	ETF	347.95	348.55	347.95	348.54	92476.0
2020-10-14 18:30:00	SPY	ETF	348.4	348.41	347.39	348.15	116215.0
2020-10-14 19:00:00	SPY	ETF	348.17	348.53	348.1	348.5	45086.0
2020-10-14 19:30:00	SPY	ETF	348.5	348.5	348.3	348.37	35450.0
2020-10-14 04:00:00	QQQ	ETF	296.36	296.62	295.94	296.17	17005.0
2020-10-14 04:30:00	QQQ	ETF	296.32	296.33	295.95	296.05	13949.0
2020-10-14 05:00:00	QQQ	ETF	296.27	296.32	295.65	295.75	7607.0
2020-10-14 05:30:00	QQQ	ETF	295.73	295.75	295.25	295.43	15505.0
2020-10-14 06:00:00	QQQ	ETF	295.49	295.65	294.3	294.92	50352.0
2020-10-14 06:30:00	QQQ	ETF	295.0	295.0	294.25	294.67	40530.0
2020-10-14 07:00:00	QQQ	ETF	294.73	295.7	294.65	295.7	76717.0
2020-10-14 07:30:00	QQQ	ETF	295.71	295.71	295.19	295.37	57749.0
2020-10-14 08:00:00	QQQ	ETF	294.91	296.75	294.52	295.57	98956.0
2020-10-14 08:30:00	QQQ	ETF	295.51	295.75	295.07	295.67	75607.0
2020-10-14 09:00:00	QQQ	ETF	295.65	295.72	295.3	295.32	72589.0
2020-10-14 09:30:00	QQQ	ETF	295.34	296.35	294.38	295.822	2969453.0
2020-10-14 10:00:00	QQQ	ETF	295.88	295.995	293.7	293.94	2257929.0
2020-10-14 10:30:00	QQQ	ETF	293.95	294.92	293.32	294.84	1921634.0
2020-10-14 11:00:00	QQQ	ETF	294.85	295.18	293.9699	294.02	1379645.0
2020-10-14 11:30:00	QQQ	ETF	294.04	294.2	291.78	291.95	2107293.0
2020-10-14 12:00:00	QQQ	ETF	292.0	292.54	290.26	291.07	3417932.0
2020-10-14 12:30:00	QQQ	ETF	291.071	291.7	290.63	291.22	2302804.0

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

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