PREVIEW / etf_30min / 2018-08-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-23.parquet
  size:    463 KB
  rows:    15,830

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
2018-08-23 04:00:00	SPY	ETF	286.09	286.12	285.94	286.09	1420.0
2018-08-23 04:30:00	SPY	ETF	286.08	286.32	286.07	286.32	302.0
2018-08-23 05:00:00	SPY	ETF	286.25	286.32	286.25	286.25	15250.0
2018-08-23 05:30:00	SPY	ETF	286.15	286.15	286.1	286.15	1900.0
2018-08-23 06:00:00	SPY	ETF	286.1	286.11	286.1	286.11	1819.0
2018-08-23 06:30:00	SPY	ETF	286.06	286.23	286.03	286.22	8200.0
2018-08-23 07:00:00	SPY	ETF	286.15	286.17	285.93	285.98	58849.0
2018-08-23 07:30:00	SPY	ETF	286.01	286.16	285.98	286.14	13788.0
2018-08-23 08:00:00	SPY	ETF	286.15	286.24	285.99	286.15	57778.0
2018-08-23 08:30:00	SPY	ETF	286.15	286.18	286.03	286.17	43454.0
2018-08-23 09:00:00	SPY	ETF	286.17	286.17	285.8	285.94	286246.0
2018-08-23 09:30:00	SPY	ETF	285.97	286.7499	285.9	286.46	4362240.0
2018-08-23 10:00:00	SPY	ETF	286.47	286.87	286.4	286.86	3313316.0
2018-08-23 10:30:00	SPY	ETF	286.8687	286.94	286.365	286.38	4454936.0
2018-08-23 11:00:00	SPY	ETF	286.37	286.45	285.5	285.74	4788938.0
2018-08-23 11:30:00	SPY	ETF	285.73	285.84	285.43	285.66	4026003.0
2018-08-23 12:00:00	SPY	ETF	285.67	286.09	285.65	286.08	2381414.0
2018-08-23 12:30:00	SPY	ETF	286.07	286.1368	285.8	285.85	1362748.0
2018-08-23 13:00:00	SPY	ETF	285.85	285.92	285.62	285.915	1610629.0
2018-08-23 13:30:00	SPY	ETF	285.915	285.93	285.69	285.77	1034409.0
2018-08-23 14:00:00	SPY	ETF	285.76	286.03	285.76	285.985	1164368.0
2018-08-23 14:30:00	SPY	ETF	285.99	286.12	285.845	285.995	1202283.0
2018-08-23 15:00:00	SPY	ETF	285.995	286.15	285.905	286.0075	1720737.0
2018-08-23 15:30:00	SPY	ETF	286.02	286.03	285.475	285.77	9831120.0
2018-08-23 16:00:00	SPY	ETF	285.76	285.9	285.5873	285.74	6222105.0
2018-08-23 16:30:00	SPY	ETF	285.75	285.85	285.75	285.8	113895.0
2018-08-23 17:00:00	SPY	ETF	285.82	285.85	285.77	285.79	10296.0
2018-08-23 17:30:00	SPY	ETF	285.79	285.81	285.77	285.77	2579.0
2018-08-23 18:00:00	SPY	ETF	285.8	285.83	285.75	285.76	17861.0
2018-08-23 18:30:00	SPY	ETF	285.77	285.78	285.75	285.78	6007.0
2018-08-23 19:00:00	SPY	ETF	285.75	285.83	285.75	285.76	3300.0
2018-08-23 19:30:00	SPY	ETF	285.85	285.86	285.69	285.72	16410.0
2018-08-23 04:00:00	QQQ	ETF	181.08	181.08	180.86	180.93	2227.0
2018-08-23 05:00:00	QQQ	ETF	181.07	181.07	181.06	181.07	1800.0
2018-08-23 05:30:00	QQQ	ETF	180.96	181.01	180.96	181.01	2437.0
2018-08-23 06:00:00	QQQ	ETF	180.99	180.99	180.96	180.96	1700.0
2018-08-23 06:30:00	QQQ	ETF	180.9	181.01	180.83	180.87	7352.0
2018-08-23 07:00:00	QQQ	ETF	180.97	181.0	180.79	180.85	24080.0
2018-08-23 07:30:00	QQQ	ETF	180.85	180.94	180.82	180.86	19452.0
2018-08-23 08:00:00	QQQ	ETF	180.87	180.96	180.8499	180.93	45620.0
2018-08-23 08:30:00	QQQ	ETF	180.93	180.93	180.8	180.91	33438.0
2018-08-23 09:00:00	QQQ	ETF	180.9	180.93	180.66	180.77	153047.0
2018-08-23 09:30:00	QQQ	ETF	180.77	181.9	180.74	181.79	2584315.0
2018-08-23 10:00:00	QQQ	ETF	181.79	182.0315	181.62	182.03	1682523.0
2018-08-23 10:30:00	QQQ	ETF	182.03	182.045	181.55	181.561	1217183.0
2018-08-23 11:00:00	QQQ	ETF	181.56	181.65	180.6	180.87	2561224.0
2018-08-23 11:30:00	QQQ	ETF	180.86	180.945	180.5	180.8	2285205.0
2018-08-23 12:00:00	QQQ	ETF	180.81	181.29	180.79	181.27	1557979.0
2018-08-23 12:30:00	QQQ	ETF	181.29	181.32	181.055	181.11	752451.0
2018-08-23 13:00:00	QQQ	ETF	181.111	181.24	180.96	181.23	614559.0

> showing 50 of 15,830 rows — these rows as CSV

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