PREVIEW / etf_30min / 2019-07-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-23.parquet
  size:    499 KB
  rows:    17,352

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-23 04:00:00	SPY	ETF	298.45	298.65	298.45	298.56	12593.0
2019-07-23 04:30:00	SPY	ETF	298.57	298.8	298.54	298.8	6759.0
2019-07-23 05:00:00	SPY	ETF	298.75	298.76	298.7	298.75	7145.0
2019-07-23 05:30:00	SPY	ETF	298.76	298.76	298.74	298.74	910.0
2019-07-23 06:00:00	SPY	ETF	298.75	298.98	298.75	298.98	16710.0
2019-07-23 06:30:00	SPY	ETF	298.93	298.98	298.87	298.9	12907.0
2019-07-23 07:00:00	SPY	ETF	298.9	299.07	298.9	298.98	52028.0
2019-07-23 07:30:00	SPY	ETF	298.97	299.08	298.85	298.91	22220.0
2019-07-23 08:00:00	SPY	ETF	298.8999	299.22	297.9	299.12	70924.0
2019-07-23 08:30:00	SPY	ETF	299.12	299.24	299.12	299.17	66141.0
2019-07-23 09:00:00	SPY	ETF	299.16	299.24	299.07	299.14	193741.0
2019-07-23 09:30:00	SPY	ETF	299.14	299.19	298.53	298.59	4147360.0
2019-07-23 10:00:00	SPY	ETF	298.59	298.72	298.26	298.42	2446058.0
2019-07-23 10:30:00	SPY	ETF	298.41	298.99	298.37	298.83	2478172.0
2019-07-23 11:00:00	SPY	ETF	298.84	298.9085	298.45	298.675	2907036.0
2019-07-23 11:30:00	SPY	ETF	298.67	298.67	298.31	298.4265	2539813.0
2019-07-23 12:00:00	SPY	ETF	298.44	298.77	298.22	298.52	1975617.0
2019-07-23 12:30:00	SPY	ETF	298.52	298.89	298.42	298.84	1431014.0
2019-07-23 13:00:00	SPY	ETF	298.85	298.94	298.73	298.8475	1926653.0
2019-07-23 13:30:00	SPY	ETF	298.86	299.855	298.86	299.75	6096436.0
2019-07-23 14:00:00	SPY	ETF	299.74	299.83	299.44	299.575	2881613.0
2019-07-23 14:30:00	SPY	ETF	299.5885	299.88	299.45	299.8	1759043.0
2019-07-23 15:00:00	SPY	ETF	299.805	299.86	299.55	299.76	2495243.0
2019-07-23 15:30:00	SPY	ETF	299.77	300.03	299.735	299.96	6273808.0
2019-07-23 16:00:00	SPY	ETF	299.96	300.09	299.76	300.03	2326639.0
2019-07-23 16:30:00	SPY	ETF	300.03	300.06	299.28	299.52	941900.0
2019-07-23 17:00:00	SPY	ETF	299.52	300.03	299.46	299.7	112331.0
2019-07-23 17:30:00	SPY	ETF	299.68	299.7	299.52	299.57	79241.0
2019-07-23 18:00:00	SPY	ETF	299.55	300.03	299.48	299.57	79553.0
2019-07-23 18:30:00	SPY	ETF	299.58	299.7	299.55	299.65	12688.0
2019-07-23 19:00:00	SPY	ETF	299.6	299.68	299.59	299.68	7119.0
2019-07-23 19:30:00	SPY	ETF	299.7	299.8	299.62	299.77	42126.0
2019-07-23 04:00:00	QQQ	ETF	192.96	193.12	192.96	193.08	29381.0
2019-07-23 04:30:00	QQQ	ETF	193.08	193.24	193.08	193.22	26900.0
2019-07-23 05:00:00	QQQ	ETF	193.2	193.22	193.15	193.22	9149.0
2019-07-23 05:30:00	QQQ	ETF	193.2	193.23	193.2	193.23	5500.0
2019-07-23 06:00:00	QQQ	ETF	193.23	193.47	193.23	193.46	10250.0
2019-07-23 06:30:00	QQQ	ETF	193.44	193.49	193.38	193.38	2180.0
2019-07-23 07:00:00	QQQ	ETF	193.4	193.5	193.34	193.42	15032.0
2019-07-23 07:30:00	QQQ	ETF	193.42	193.47	193.29	193.3	13796.0
2019-07-23 08:00:00	QQQ	ETF	193.39	193.5399	192.78	193.51	116988.0
2019-07-23 08:30:00	QQQ	ETF	193.53	193.63	193.49	193.5	55227.0
2019-07-23 09:00:00	QQQ	ETF	193.47	193.58	193.43	193.54	51663.0
2019-07-23 09:30:00	QQQ	ETF	193.58	193.595	192.825	192.87	1759995.0
2019-07-23 10:00:00	QQQ	ETF	192.8768	193.02	192.41	192.66	1602061.0
2019-07-23 10:30:00	QQQ	ETF	192.66	193.17	192.62	193.02	985193.0
2019-07-23 11:00:00	QQQ	ETF	193.015	193.13	192.72	192.97	698387.0
2019-07-23 11:30:00	QQQ	ETF	192.97	192.99	192.45	192.58	809643.0
2019-07-23 12:00:00	QQQ	ETF	192.5701	192.75	192.29	192.55	805962.0
2019-07-23 12:30:00	QQQ	ETF	192.54	192.9	192.46	192.86	339440.0

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

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