PREVIEW / etf_30min / 2019-11-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-26.parquet
  size:    515 KB
  rows:    18,123

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-26 04:00:00	SPY	ETF	313.26	313.29	312.89	313.03	11888.0
2019-11-26 04:30:00	SPY	ETF	313.02	313.14	313.02	313.1	7217.0
2019-11-26 05:00:00	SPY	ETF	313.13	313.17	313.05	313.13	8290.0
2019-11-26 05:30:00	SPY	ETF	313.21	313.33	313.2	313.29	12130.0
2019-11-26 06:00:00	SPY	ETF	313.28	313.32	313.23	313.25	24731.0
2019-11-26 06:30:00	SPY	ETF	313.24	313.39	313.23	313.26	4737.0
2019-11-26 07:00:00	SPY	ETF	313.24	313.37	313.2	313.33	16884.0
2019-11-26 07:30:00	SPY	ETF	313.32	313.41	313.32	313.34	39839.0
2019-11-26 08:00:00	SPY	ETF	313.2499	313.6	313.2	313.4	229746.0
2019-11-26 08:30:00	SPY	ETF	313.36	313.51	313.36	313.41	56688.0
2019-11-26 09:00:00	SPY	ETF	313.38	313.54	313.28	313.43	218218.0
2019-11-26 09:30:00	SPY	ETF	313.41	313.81	313.06	313.74	3420518.0
2019-11-26 10:00:00	SPY	ETF	313.75	313.87	313.41	313.62	3160928.0
2019-11-26 10:30:00	SPY	ETF	313.6136	313.83	313.4808	313.7	2195792.0
2019-11-26 11:00:00	SPY	ETF	313.7	313.94	313.57	313.85	2072582.0
2019-11-26 11:30:00	SPY	ETF	313.84	313.97	313.55	313.915	2797305.0
2019-11-26 12:00:00	SPY	ETF	313.92	314.13	313.8	314.12	1376643.0
2019-11-26 12:30:00	SPY	ETF	314.12	314.18	313.99	314.03	1367049.0
2019-11-26 13:00:00	SPY	ETF	314.035	314.08	313.75	313.795	2258378.0
2019-11-26 13:30:00	SPY	ETF	313.79	313.8	313.53	313.67	1507674.0
2019-11-26 14:00:00	SPY	ETF	313.675	313.85	313.64	313.75	1264138.0
2019-11-26 14:30:00	SPY	ETF	313.75	313.85	313.62	313.78	1478418.0
2019-11-26 15:00:00	SPY	ETF	313.78	313.8	313.46	313.67	2422279.0
2019-11-26 15:30:00	SPY	ETF	313.67	314.28	313.64	314.02	6424181.0
2019-11-26 16:00:00	SPY	ETF	314.03	314.45	313.98	314.42	3651401.0
2019-11-26 16:30:00	SPY	ETF	314.42	314.5	314.41	314.46	186284.0
2019-11-26 17:00:00	SPY	ETF	314.47	314.47	314.29	314.31	104804.0
2019-11-26 17:30:00	SPY	ETF	314.39	314.45	313.353	314.41	202703.0
2019-11-26 18:00:00	SPY	ETF	314.42	314.42	314.3	314.39	101101.0
2019-11-26 18:30:00	SPY	ETF	314.39	314.42	314.34	314.39	25836.0
2019-11-26 19:00:00	SPY	ETF	314.38	314.59	314.36	314.5	32350.0
2019-11-26 19:30:00	SPY	ETF	314.48	314.48	314.26	314.42	49050.0
2019-11-26 04:00:00	QQQ	ETF	204.28	204.28	204.01	204.05	9760.0
2019-11-26 04:30:00	QQQ	ETF	204.02	204.16	204.02	204.16	1350.0
2019-11-26 05:00:00	QQQ	ETF	204.07	204.2	204.07	204.2	1350.0
2019-11-26 05:30:00	QQQ	ETF	204.23	204.28	204.23	204.28	4100.0
2019-11-26 06:00:00	QQQ	ETF	204.29	204.29	204.18	204.19	6852.0
2019-11-26 06:30:00	QQQ	ETF	204.22	204.35	204.19	204.21	8860.0
2019-11-26 07:00:00	QQQ	ETF	204.2	204.32	204.2	204.3	7530.0
2019-11-26 07:30:00	QQQ	ETF	204.28	204.33	204.24	204.28	13363.0
2019-11-26 08:00:00	QQQ	ETF	204.27	204.58	204.11	204.29	81636.0
2019-11-26 08:30:00	QQQ	ETF	204.3	204.38	204.24	204.28	27574.0
2019-11-26 09:00:00	QQQ	ETF	204.26	205.26	204.22	204.32	37291.0
2019-11-26 09:30:00	QQQ	ETF	204.32	204.57	204.05	204.5	1602431.0
2019-11-26 10:00:00	QQQ	ETF	204.52	204.59	204.18	204.48	965763.0
2019-11-26 10:30:00	QQQ	ETF	204.48	204.6494	204.32	204.56	895516.0
2019-11-26 11:00:00	QQQ	ETF	204.56	204.74	204.48	204.61	512281.0
2019-11-26 11:30:00	QQQ	ETF	204.6	204.72	204.38	204.631	999979.0
2019-11-26 12:00:00	QQQ	ETF	204.64	204.8066	204.54	204.805	418088.0
2019-11-26 12:30:00	QQQ	ETF	204.8	204.87	204.77	204.83	507007.0

> showing 50 of 18,123 rows — these rows as CSV

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