PREVIEW / etf_30min / 2019-07-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-09.parquet
  size:    491 KB
  rows:    17,327

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-09 04:00:00	SPY	ETF	295.39	295.5	295.31	295.5	5000.0
2019-07-09 04:30:00	SPY	ETF	295.45	295.51	295.3	295.5	4455.0
2019-07-09 05:00:00	SPY	ETF	295.5	295.55	295.31	295.38	14932.0
2019-07-09 05:30:00	SPY	ETF	295.35	295.48	295.31	295.43	7343.0
2019-07-09 06:00:00	SPY	ETF	295.41	295.58	295.33	295.53	14444.0
2019-07-09 06:30:00	SPY	ETF	295.62	295.78	295.59	295.64	18019.0
2019-07-09 07:00:00	SPY	ETF	295.7	295.82	295.62	295.8	33087.0
2019-07-09 07:30:00	SPY	ETF	295.79	295.81	295.67	295.73	51934.0
2019-07-09 08:00:00	SPY	ETF	295.71	295.87	295.65	295.75	269152.0
2019-07-09 08:30:00	SPY	ETF	295.77	295.83	295.56	295.7301	92900.0
2019-07-09 09:00:00	SPY	ETF	295.74	295.75	295.49	295.54	101549.0
2019-07-09 09:30:00	SPY	ETF	295.54	296.9007	295.48	296.0749	5112905.0
2019-07-09 10:00:00	SPY	ETF	296.08	296.41	296.07	296.35	3012196.0
2019-07-09 10:30:00	SPY	ETF	296.34	296.73	296.31	296.475	2730952.0
2019-07-09 11:00:00	SPY	ETF	296.47	296.86	296.41	296.6025	2217071.0
2019-07-09 11:30:00	SPY	ETF	296.6	296.77	296.48	296.64	1906679.0
2019-07-09 12:00:00	SPY	ETF	296.65	296.815	296.62	296.76	1227393.0
2019-07-09 12:30:00	SPY	ETF	296.76	296.865	296.69	296.71	874428.0
2019-07-09 13:00:00	SPY	ETF	296.71	296.79	296.59	296.76	990521.0
2019-07-09 13:30:00	SPY	ETF	296.75	296.83	296.725	296.79	1479621.0
2019-07-09 14:00:00	SPY	ETF	296.79	296.98	296.69	296.87	1250068.0
2019-07-09 14:30:00	SPY	ETF	296.86	296.9	296.77	296.86	1776366.0
2019-07-09 15:00:00	SPY	ETF	296.86	296.93	296.55	296.67	2207161.0
2019-07-09 15:30:00	SPY	ETF	296.67	297.52	296.64	297.26	9026504.0
2019-07-09 16:00:00	SPY	ETF	297.25	297.2677	297.0	297.08	4948760.0
2019-07-09 16:30:00	SPY	ETF	297.09	297.22	296.9007	297.15	271247.0
2019-07-09 17:00:00	SPY	ETF	297.13	297.19	297.0	297.12	108549.0
2019-07-09 17:30:00	SPY	ETF	297.1	297.19	297.06	297.07	19389.0
2019-07-09 18:00:00	SPY	ETF	297.07	297.15	297.05	297.12	24313.0
2019-07-09 18:30:00	SPY	ETF	297.14	297.14	297.01	297.05	6762.0
2019-07-09 19:00:00	SPY	ETF	297.04	297.05	297.01	297.03	2371.0
2019-07-09 19:30:00	SPY	ETF	297.05	297.1	296.95	297.08	23902.0
2019-07-09 04:00:00	QQQ	ETF	188.15	188.33	188.1	188.29	17817.0
2019-07-09 04:30:00	QQQ	ETF	188.32	188.41	188.16	188.38	9840.0
2019-07-09 05:00:00	QQQ	ETF	188.31	188.32	188.23	188.28	4900.0
2019-07-09 05:30:00	QQQ	ETF	188.28	188.41	188.19	188.39	12630.0
2019-07-09 06:00:00	QQQ	ETF	188.38	188.55	188.36	188.54	11095.0
2019-07-09 06:30:00	QQQ	ETF	188.53	188.64	188.5	188.56	13623.0
2019-07-09 07:00:00	QQQ	ETF	188.53	188.81	188.53	188.81	62456.0
2019-07-09 07:30:00	QQQ	ETF	188.77	188.82	188.71	188.82	23030.0
2019-07-09 08:00:00	QQQ	ETF	188.57	188.9	188.3	188.85	46494.0
2019-07-09 08:30:00	QQQ	ETF	188.87	188.9099	188.67	188.85	66902.0
2019-07-09 09:00:00	QQQ	ETF	188.85	188.88	188.66	188.8	71058.0
2019-07-09 09:30:00	QQQ	ETF	188.79	189.5	188.65	189.43	2824074.0
2019-07-09 10:00:00	QQQ	ETF	189.44	189.8627	189.43	189.81	1269253.0
2019-07-09 10:30:00	QQQ	ETF	189.81	190.1197	189.75	189.94	922840.0
2019-07-09 11:00:00	QQQ	ETF	189.93	190.32	189.8837	190.09	1093303.0
2019-07-09 11:30:00	QQQ	ETF	190.09	190.259	189.94	190.24	913113.0
2019-07-09 12:00:00	QQQ	ETF	190.23	190.43	190.2	190.35	883832.0
2019-07-09 12:30:00	QQQ	ETF	190.35	190.55	190.32	190.36	588085.0

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

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