PREVIEW / etf_30min / 2019-07-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-17.parquet
  size:    498 KB
  rows:    17,294

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-07-17 04:00:00	SPY	ETF	300.03	300.33	300.03	300.18	21244.0
2019-07-17 04:30:00	SPY	ETF	300.16	300.18	300.06	300.06	4079.0
2019-07-17 05:00:00	SPY	ETF	300.06	300.25	300.06	300.18	10110.0
2019-07-17 05:30:00	SPY	ETF	300.25	300.25	300.18	300.2	2240.0
2019-07-17 06:00:00	SPY	ETF	300.26	300.26	300.03	300.11	2560.0
2019-07-17 06:30:00	SPY	ETF	300.03	300.03	299.89	299.89	7816.0
2019-07-17 07:00:00	SPY	ETF	299.93	299.93	299.77	299.8	28566.0
2019-07-17 07:30:00	SPY	ETF	299.78	299.92	299.63	299.92	47917.0
2019-07-17 08:00:00	SPY	ETF	299.8585	299.95	299.6301	299.89	103238.0
2019-07-17 08:30:00	SPY	ETF	299.91	299.91	299.58	299.64	220697.0
2019-07-17 09:00:00	SPY	ETF	299.62	299.86	299.56	299.76	86587.0
2019-07-17 09:30:00	SPY	ETF	299.75	299.93	299.4	299.545	3258910.0
2019-07-17 10:00:00	SPY	ETF	299.55	299.67	299.03	299.04	2430019.0
2019-07-17 10:30:00	SPY	ETF	299.04	299.18	298.33	298.695	4381650.0
2019-07-17 11:00:00	SPY	ETF	298.69	298.98	298.66	298.7999	2534558.0
2019-07-17 11:30:00	SPY	ETF	298.79	299.25	298.73	299.08	2060658.0
2019-07-17 12:00:00	SPY	ETF	299.08	299.12	298.77	298.84	1463190.0
2019-07-17 12:30:00	SPY	ETF	298.8499	299.0	298.82	298.94	851403.0
2019-07-17 13:00:00	SPY	ETF	298.94	298.99	298.75	298.87	1938073.0
2019-07-17 13:30:00	SPY	ETF	298.87	299.13	298.8534	298.99	1062428.0
2019-07-17 14:00:00	SPY	ETF	298.98	298.9904	298.45	298.66	2041562.0
2019-07-17 14:30:00	SPY	ETF	298.665	298.8	298.53	298.603	1248315.0
2019-07-17 15:00:00	SPY	ETF	298.605	298.6762	298.15	298.195	2546392.0
2019-07-17 15:30:00	SPY	ETF	298.19	298.46	297.76	297.77	7894918.0
2019-07-17 16:00:00	SPY	ETF	297.79	298.07	297.48	297.62	5836619.0
2019-07-17 16:30:00	SPY	ETF	297.62	297.7953	297.11	297.2	1883891.0
2019-07-17 17:00:00	SPY	ETF	297.2	297.29	297.17	297.17	164235.0
2019-07-17 17:30:00	SPY	ETF	297.21	297.74	297.11	297.11	37839.0
2019-07-17 18:00:00	SPY	ETF	297.19	297.45	297.19	297.4	46259.0
2019-07-17 18:30:00	SPY	ETF	297.41	297.42	297.31	297.33	62188.0
2019-07-17 19:00:00	SPY	ETF	297.33	297.34	297.24	297.25	61055.0
2019-07-17 19:30:00	SPY	ETF	297.33	297.39	297.14	297.23	31018.0
2019-07-17 04:00:00	QQQ	ETF	193.31	193.49	193.31	193.49	3965.0
2019-07-17 04:30:00	QQQ	ETF	193.5	193.5	193.42	193.42	5869.0
2019-07-17 05:00:00	QQQ	ETF	193.43	193.53	193.43	193.47	2171.0
2019-07-17 05:30:00	QQQ	ETF	193.46	193.54	193.46	193.54	1300.0
2019-07-17 06:00:00	QQQ	ETF	193.53	193.53	193.36	193.37	8650.0
2019-07-17 06:30:00	QQQ	ETF	193.35	193.36	193.25	193.3	4400.0
2019-07-17 07:00:00	QQQ	ETF	193.34	193.34	193.19	193.27	7854.0
2019-07-17 07:30:00	QQQ	ETF	193.27	193.3	193.09	193.3	18912.0
2019-07-17 08:00:00	QQQ	ETF	193.1901	193.34	193.1901	193.25	36486.0
2019-07-17 08:30:00	QQQ	ETF	193.28	193.28	193.0	193.09	39877.0
2019-07-17 09:00:00	QQQ	ETF	193.08	193.24	193.0	193.2	81735.0
2019-07-17 09:30:00	QQQ	ETF	193.2	193.49	193.08	193.35	1433604.0
2019-07-17 10:00:00	QQQ	ETF	193.36	193.44	192.89	192.98	890290.0
2019-07-17 10:30:00	QQQ	ETF	192.97	193.15	192.49	192.76	1332573.0
2019-07-17 11:00:00	QQQ	ETF	192.78	192.95	192.69	192.81	769098.0
2019-07-17 11:30:00	QQQ	ETF	192.8	193.13	192.71	193.0	642594.0
2019-07-17 12:00:00	QQQ	ETF	193.01	193.07	192.82	192.89	501398.0
2019-07-17 12:30:00	QQQ	ETF	192.9	193.09	192.89	193.02	396582.0

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

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