PREVIEW / etf_30min / 2019-10-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-16.parquet
  size:    498 KB
  rows:    17,348

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-10-16 04:00:00	SPY	ETF	298.54	298.54	298.11	298.21	6050.0
2019-10-16 04:30:00	SPY	ETF	298.23	298.38	298.15	298.38	2251.0
2019-10-16 05:00:00	SPY	ETF	298.23	298.23	297.91	298.16	7131.0
2019-10-16 05:30:00	SPY	ETF	298.15	298.25	298.15	298.19	6450.0
2019-10-16 06:00:00	SPY	ETF	298.29	298.61	298.29	298.4	5047.0
2019-10-16 06:30:00	SPY	ETF	298.43	298.48	298.24	298.48	39292.0
2019-10-16 07:00:00	SPY	ETF	298.49	298.64	298.29	298.6	82585.0
2019-10-16 07:30:00	SPY	ETF	298.58	298.76	298.5	298.6	84410.0
2019-10-16 08:00:00	SPY	ETF	298.6	299.12	297.93	298.97	207643.0
2019-10-16 08:30:00	SPY	ETF	298.69	298.81	298.34	298.6	254035.0
2019-10-16 09:00:00	SPY	ETF	298.59	298.64	298.35	298.4	130701.0
2019-10-16 09:30:00	SPY	ETF	298.37	298.65	298.03	298.16	4709773.0
2019-10-16 10:00:00	SPY	ETF	298.155	298.75	297.92	298.72	5608219.0
2019-10-16 10:30:00	SPY	ETF	298.73	299.03	298.57	299.02	2528455.0
2019-10-16 11:00:00	SPY	ETF	299.0	299.16	298.6751	298.7299	1887328.0
2019-10-16 11:30:00	SPY	ETF	298.72	299.08	298.43	298.665	2690852.0
2019-10-16 12:00:00	SPY	ETF	298.67	298.87	298.42	298.505	1307168.0
2019-10-16 12:30:00	SPY	ETF	298.51	298.571	298.18	298.21	1407634.0
2019-10-16 13:00:00	SPY	ETF	298.21	298.36	297.99	298.08	1655271.0
2019-10-16 13:30:00	SPY	ETF	298.09	298.38	298.0	298.1	2340546.0
2019-10-16 14:00:00	SPY	ETF	298.1	298.35	298.02	298.28	1959034.0
2019-10-16 14:30:00	SPY	ETF	298.27	298.72	298.27	298.56	3057632.0
2019-10-16 15:00:00	SPY	ETF	298.56	298.589	298.12	298.3	4621833.0
2019-10-16 15:30:00	SPY	ETF	298.29	298.54	298.17	298.41	6991627.0
2019-10-16 16:00:00	SPY	ETF	298.44	298.64	298.4	298.48	5529634.0
2019-10-16 16:30:00	SPY	ETF	298.52	298.66	298.51	298.6	139479.0
2019-10-16 17:00:00	SPY	ETF	298.59	298.67	298.4	298.64	1161247.0
2019-10-16 17:30:00	SPY	ETF	298.61	298.61	298.4	298.54	11907.0
2019-10-16 18:00:00	SPY	ETF	298.6	298.64	298.4	298.4	90223.0
2019-10-16 18:30:00	SPY	ETF	298.44	298.45	298.27	298.31	80990.0
2019-10-16 19:00:00	SPY	ETF	298.32	298.42	298.3	298.3	23021.0
2019-10-16 19:30:00	SPY	ETF	298.33	298.39	298.18	298.25	75156.0
2019-10-16 04:00:00	QQQ	ETF	193.28	193.3	193.07	193.16	14244.0
2019-10-16 04:30:00	QQQ	ETF	193.1	193.12	193.1	193.12	405.0
2019-10-16 05:00:00	QQQ	ETF	193.19	193.19	192.81	193.15	11090.0
2019-10-16 05:30:00	QQQ	ETF	193.16	193.2	193.09	193.09	1450.0
2019-10-16 06:00:00	QQQ	ETF	193.24	193.38	193.22	193.31	5400.0
2019-10-16 06:30:00	QQQ	ETF	193.21	193.27	193.11	193.19	20084.0
2019-10-16 07:00:00	QQQ	ETF	193.2	193.3	193.06	193.27	20342.0
2019-10-16 07:30:00	QQQ	ETF	193.26	193.34	193.16	193.19	32732.0
2019-10-16 08:00:00	QQQ	ETF	193.1801	193.53	193.05	193.43	84699.0
2019-10-16 08:30:00	QQQ	ETF	193.1	193.25	193.02	193.17	101327.0
2019-10-16 09:00:00	QQQ	ETF	193.17	193.2	192.89	192.89	63505.0
2019-10-16 09:30:00	QQQ	ETF	192.89	193.082	192.64	192.74	2479460.0
2019-10-16 10:00:00	QQQ	ETF	192.74	193.16	192.43	193.12	1663585.0
2019-10-16 10:30:00	QQQ	ETF	193.11	193.41	192.96	193.34	1253485.0
2019-10-16 11:00:00	QQQ	ETF	193.345	193.53	193.01	193.02	1022746.0
2019-10-16 11:30:00	QQQ	ETF	193.02	193.29	192.78	193.0	1508715.0
2019-10-16 12:00:00	QQQ	ETF	193.0	193.15	192.8016	192.8866	559951.0
2019-10-16 12:30:00	QQQ	ETF	192.89	192.93	192.67	192.6939	533409.0

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

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