PREVIEW / etf_30min / 2019-11-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-25.parquet
  size:    512 KB
  rows:    17,935

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
2019-11-25 04:00:00	SPY	ETF	312.0	312.03	311.86	312.01	9503.0
2019-11-25 04:30:00	SPY	ETF	311.96	311.98	311.91	311.98	6780.0
2019-11-25 05:00:00	SPY	ETF	312.01	312.01	311.93	311.96	10270.0
2019-11-25 05:30:00	SPY	ETF	311.98	312.06	311.98	312.03	11093.0
2019-11-25 06:00:00	SPY	ETF	311.99	312.01	311.86	311.87	3203.0
2019-11-25 06:30:00	SPY	ETF	311.89	311.91	311.85	311.9	2813.0
2019-11-25 07:00:00	SPY	ETF	311.9	312.03	311.8	311.8	47343.0
2019-11-25 07:30:00	SPY	ETF	311.85	311.9	311.82	311.87	81246.0
2019-11-25 08:00:00	SPY	ETF	311.83	312.17	311.76	311.9	115903.0
2019-11-25 08:30:00	SPY	ETF	311.95	312.13	311.93	312.09	155779.0
2019-11-25 09:00:00	SPY	ETF	312.0999	312.1	311.96	311.96	229640.0
2019-11-25 09:30:00	SPY	ETF	311.98	312.75	311.98	312.715	5665969.0
2019-11-25 10:00:00	SPY	ETF	312.705	312.97	312.68	312.94	3655020.0
2019-11-25 10:30:00	SPY	ETF	312.94	313.15	312.85	312.885	4380778.0
2019-11-25 11:00:00	SPY	ETF	312.88	312.96	312.705	312.91	2351074.0
2019-11-25 11:30:00	SPY	ETF	312.91	313.0	312.76	312.92	2333952.0
2019-11-25 12:00:00	SPY	ETF	312.92	312.97	312.78	312.79	1455178.0
2019-11-25 12:30:00	SPY	ETF	312.79	312.91	312.78	312.905	925874.0
2019-11-25 13:00:00	SPY	ETF	312.91	313.08	312.91	312.96	1215460.0
2019-11-25 13:30:00	SPY	ETF	312.96	312.99	312.83	312.905	1167574.0
2019-11-25 14:00:00	SPY	ETF	312.9	313.04	312.84	312.9378	2849692.0
2019-11-25 14:30:00	SPY	ETF	312.94	312.98	312.86	312.94	1130499.0
2019-11-25 15:00:00	SPY	ETF	312.94	313.255	312.92	313.24	2687288.0
2019-11-25 15:30:00	SPY	ETF	313.25	313.37	312.95	313.35	8809792.0
2019-11-25 16:00:00	SPY	ETF	313.35	313.38	313.12	313.26	7447634.0
2019-11-25 16:30:00	SPY	ETF	313.28	313.37	313.18	313.2	205727.0
2019-11-25 17:00:00	SPY	ETF	313.18	313.23	313.11	313.18	101561.0
2019-11-25 17:30:00	SPY	ETF	313.16	313.23	313.16	313.2	27912.0
2019-11-25 18:00:00	SPY	ETF	313.18	313.19	313.09	313.18	41480.0
2019-11-25 18:30:00	SPY	ETF	313.17	313.26	313.17	313.25	6396.0
2019-11-25 19:00:00	SPY	ETF	313.26	313.46	313.22	313.46	36689.0
2019-11-25 19:30:00	SPY	ETF	313.48	313.7	313.46	313.68	69792.0
2019-11-25 04:00:00	QQQ	ETF	202.56	202.64	202.52	202.62	25167.0
2019-11-25 04:30:00	QQQ	ETF	202.6	202.63	202.56	202.63	9048.0
2019-11-25 05:00:00	QQQ	ETF	202.6	202.61	202.57	202.59	1900.0
2019-11-25 05:30:00	QQQ	ETF	202.61	202.66	202.59	202.63	12600.0
2019-11-25 06:00:00	QQQ	ETF	202.6	202.63	202.53	202.53	5105.0
2019-11-25 06:30:00	QQQ	ETF	202.49	202.56	202.49	202.54	5200.0
2019-11-25 07:00:00	QQQ	ETF	202.54	202.62	202.41	202.47	26866.0
2019-11-25 07:30:00	QQQ	ETF	202.51	202.51	202.44	202.51	15081.0
2019-11-25 08:00:00	QQQ	ETF	202.4101	202.62	202.4	202.5799	105321.0
2019-11-25 08:30:00	QQQ	ETF	202.56	202.74	202.56	202.72	35398.0
2019-11-25 09:00:00	QQQ	ETF	202.73	202.75	202.64	202.64	40204.0
2019-11-25 09:30:00	QQQ	ETF	202.66	203.6551	202.66	203.6	2124489.0
2019-11-25 10:00:00	QQQ	ETF	203.6	203.83	203.52	203.81	937840.0
2019-11-25 10:30:00	QQQ	ETF	203.82	204.1	203.81	203.936	1033915.0
2019-11-25 11:00:00	QQQ	ETF	203.93	204.0	203.85	203.94	542498.0
2019-11-25 11:30:00	QQQ	ETF	203.94	203.955	203.8	203.92	520786.0
2019-11-25 12:00:00	QQQ	ETF	203.91	203.93	203.81	203.83	1104729.0
2019-11-25 12:30:00	QQQ	ETF	203.825	203.91	203.82	203.89	454196.0

> showing 50 of 17,935 rows — these rows as CSV

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