PREVIEW / etf_30min / 2019-01-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-23.parquet
  size:    496 KB
  rows:    17,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
2019-01-23 04:00:00	SPY	ETF	262.72	263.0	262.72	263.0	4116.0
2019-01-23 04:30:00	SPY	ETF	263.0	263.32	262.95	263.32	4544.0
2019-01-23 05:00:00	SPY	ETF	263.23	263.36	263.23	263.36	1792.0
2019-01-23 05:30:00	SPY	ETF	263.35	263.57	263.28	263.3	38492.0
2019-01-23 06:00:00	SPY	ETF	263.33	263.4	263.07	263.12	27178.0
2019-01-23 06:30:00	SPY	ETF	263.2	263.58	263.19	263.54	57204.0
2019-01-23 07:00:00	SPY	ETF	263.47	264.17	263.43	264.14	232541.0
2019-01-23 07:30:00	SPY	ETF	264.09	264.2	263.87	263.9	110997.0
2019-01-23 08:00:00	SPY	ETF	263.92	264.2	262.31	263.71	468979.0
2019-01-23 08:30:00	SPY	ETF	263.72	263.85	263.51	263.78	172303.0
2019-01-23 09:00:00	SPY	ETF	263.78	264.09	263.72	264.02	291412.0
2019-01-23 09:30:00	SPY	ETF	264.01	264.66	263.89	264.46	7260658.0
2019-01-23 10:00:00	SPY	ETF	264.465	264.79	263.45	263.545	5890829.0
2019-01-23 10:30:00	SPY	ETF	263.55	263.71	262.66	262.86	6354345.0
2019-01-23 11:00:00	SPY	ETF	262.86	263.28	262.02	262.41	5983275.0
2019-01-23 11:30:00	SPY	ETF	262.42	262.63	261.01	261.28	6242359.0
2019-01-23 12:00:00	SPY	ETF	261.29	261.58	260.66	261.47	7638402.0
2019-01-23 12:30:00	SPY	ETF	261.4615	262.22	261.39	262.1343	3975522.0
2019-01-23 13:00:00	SPY	ETF	262.1327	262.42	261.53	262.09	3793984.0
2019-01-23 13:30:00	SPY	ETF	262.09	262.61	262.07	262.45	3484286.0
2019-01-23 14:00:00	SPY	ETF	262.46	262.97	262.25	262.77	4896074.0
2019-01-23 14:30:00	SPY	ETF	262.77	262.78	261.93	262.29	4848866.0
2019-01-23 15:00:00	SPY	ETF	262.29	263.37	262.26	263.2432	5368693.0
2019-01-23 15:30:00	SPY	ETF	263.25	263.4	262.81	263.31	9907888.0
2019-01-23 16:00:00	SPY	ETF	263.315	263.42	262.7	263.2	5417012.0
2019-01-23 16:30:00	SPY	ETF	263.2	263.38	263.16	263.17	249465.0
2019-01-23 17:00:00	SPY	ETF	263.17	263.26	262.96	263.08	89916.0
2019-01-23 17:30:00	SPY	ETF	263.08	263.14	262.95	262.95	31442.0
2019-01-23 18:00:00	SPY	ETF	262.95	263.25	262.93	263.03	1451630.0
2019-01-23 18:30:00	SPY	ETF	263.08	263.41	262.65	262.8	159624.0
2019-01-23 19:00:00	SPY	ETF	262.74	263.06	262.58	262.85	53638.0
2019-01-23 19:30:00	SPY	ETF	262.88	263.2	262.88	263.06	33664.0
2019-01-23 04:00:00	QQQ	ETF	161.77	162.03	161.77	161.98	2321.0
2019-01-23 04:30:00	QQQ	ETF	162.07	162.25	162.07	162.2	10468.0
2019-01-23 05:00:00	QQQ	ETF	162.33	162.33	162.19	162.33	3361.0
2019-01-23 05:30:00	QQQ	ETF	162.34	162.39	162.21	162.25	14200.0
2019-01-23 06:00:00	QQQ	ETF	162.26	162.26	162.12	162.12	5965.0
2019-01-23 06:30:00	QQQ	ETF	162.16	162.35	162.13	162.35	6665.0
2019-01-23 07:00:00	QQQ	ETF	162.33	162.75	162.33	162.75	42362.0
2019-01-23 07:30:00	QQQ	ETF	162.74	162.78	162.58	162.63	83989.0
2019-01-23 08:00:00	QQQ	ETF	162.41	162.77	161.58	162.52	123821.0
2019-01-23 08:30:00	QQQ	ETF	162.5	162.62	162.34	162.5701	129143.0
2019-01-23 09:00:00	QQQ	ETF	162.59	162.83	162.56	162.76	166132.0
2019-01-23 09:30:00	QQQ	ETF	162.76	163.49	162.7	163.25	3476015.0
2019-01-23 10:00:00	QQQ	ETF	163.24	163.51	162.49	162.59	2398691.0
2019-01-23 10:30:00	QQQ	ETF	162.5501	162.8	161.89	162.06	2587294.0
2019-01-23 11:00:00	QQQ	ETF	162.05	162.27	161.34	161.58	2481043.0
2019-01-23 11:30:00	QQQ	ETF	161.59	161.79	160.64	160.85	2413867.0
2019-01-23 12:00:00	QQQ	ETF	160.84	160.97	160.32	160.8438	2894228.0
2019-01-23 12:30:00	QQQ	ETF	160.84	161.36	160.77	161.28	1834064.0

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

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