PREVIEW / etf_30min / 2019-03-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-06.parquet
  size:    491 KB
  rows:    17,193

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-03-06 04:00:00	SPY	ETF	278.67	278.88	278.67	278.81	3587.0
2019-03-06 04:30:00	SPY	ETF	278.87	278.9	278.77	278.77	1238.0
2019-03-06 05:00:00	SPY	ETF	278.7	278.81	278.65	278.81	3425.0
2019-03-06 05:30:00	SPY	ETF	278.8	278.8	278.73	278.8	3000.0
2019-03-06 06:00:00	SPY	ETF	278.79	278.92	278.79	278.91	3450.0
2019-03-06 06:30:00	SPY	ETF	278.83	278.89	278.8	278.88	6038.0
2019-03-06 07:00:00	SPY	ETF	278.83	278.86	278.69	278.71	73096.0
2019-03-06 07:30:00	SPY	ETF	278.73	278.77	278.61	278.64	74529.0
2019-03-06 08:00:00	SPY	ETF	278.66	278.9	278.31	278.59	109524.0
2019-03-06 08:30:00	SPY	ETF	278.58	279.07	278.53	278.9701	250684.0
2019-03-06 09:00:00	SPY	ETF	279.0	279.35	279.0	279.16	354205.0
2019-03-06 09:30:00	SPY	ETF	279.15	279.16	278.23	278.57	6483238.0
2019-03-06 10:00:00	SPY	ETF	278.57	278.74	278.0	278.0439	5068803.0
2019-03-06 10:30:00	SPY	ETF	278.04	278.31	277.67	278.1499	5392289.0
2019-03-06 11:00:00	SPY	ETF	278.145	278.53	277.9016	278.04	3534208.0
2019-03-06 11:30:00	SPY	ETF	278.05	278.19	277.34	277.6	4380484.0
2019-03-06 12:00:00	SPY	ETF	277.59	278.11	277.32	277.42	3814293.0
2019-03-06 12:30:00	SPY	ETF	277.42	277.8	277.2	277.25	3661285.0
2019-03-06 13:00:00	SPY	ETF	277.24	277.46	277.06	277.19	3556618.0
2019-03-06 13:30:00	SPY	ETF	277.19	277.84	277.19	277.8	3040483.0
2019-03-06 14:00:00	SPY	ETF	277.8	277.97	277.65	277.74	2849943.0
2019-03-06 14:30:00	SPY	ETF	277.75	277.85	277.41	277.57	2517834.0
2019-03-06 15:00:00	SPY	ETF	277.56	277.79	276.97	277.25	6965483.0
2019-03-06 15:30:00	SPY	ETF	277.25	277.71	277.2	277.3	10708317.0
2019-03-06 16:00:00	SPY	ETF	277.29	277.6038	277.22	277.26	7965288.0
2019-03-06 16:30:00	SPY	ETF	277.24	277.33	277.15	277.24	459448.0
2019-03-06 17:00:00	SPY	ETF	277.26	277.29	277.1	277.12	300349.0
2019-03-06 17:30:00	SPY	ETF	277.15	277.17	277.12	277.13	51093.0
2019-03-06 18:00:00	SPY	ETF	277.16	277.33	277.1	277.2	47458.0
2019-03-06 18:30:00	SPY	ETF	277.2	277.29	276.72	276.94	45109.0
2019-03-06 19:00:00	SPY	ETF	276.97	276.97	276.73	276.81	35440.0
2019-03-06 19:30:00	SPY	ETF	276.8	276.93	276.74	276.76	49841.0
2019-03-06 04:00:00	QQQ	ETF	174.48	174.58	174.44	174.58	3007.0
2019-03-06 04:30:00	QQQ	ETF	174.56	174.58	174.56	174.57	1234.0
2019-03-06 05:00:00	QQQ	ETF	174.49	174.57	174.49	174.57	4000.0
2019-03-06 05:30:00	QQQ	ETF	174.55	174.57	174.5	174.54	9669.0
2019-03-06 06:00:00	QQQ	ETF	174.55	174.62	174.55	174.61	2569.0
2019-03-06 06:30:00	QQQ	ETF	174.57	174.58	174.54	174.55	2800.0
2019-03-06 07:00:00	QQQ	ETF	174.57	174.57	174.38	174.39	33726.0
2019-03-06 07:30:00	QQQ	ETF	174.39	174.42	174.27	174.31	94116.0
2019-03-06 08:00:00	QQQ	ETF	174.57	174.57	174.16	174.34	88360.0
2019-03-06 08:30:00	QQQ	ETF	174.28	174.66	174.26	174.63	91497.0
2019-03-06 09:00:00	QQQ	ETF	174.63	174.8	174.63	174.68	129230.0
2019-03-06 09:30:00	QQQ	ETF	174.68	174.75	174.12	174.46	3112772.0
2019-03-06 10:00:00	QQQ	ETF	174.45	174.61	173.87	173.95	1779815.0
2019-03-06 10:30:00	QQQ	ETF	173.9578	174.07	173.54	173.98	1632720.0
2019-03-06 11:00:00	QQQ	ETF	173.98	174.2685	173.7	173.8	1273814.0
2019-03-06 11:30:00	QQQ	ETF	173.8	173.885	173.38	173.65	1220601.0
2019-03-06 12:00:00	QQQ	ETF	173.65	173.98	173.46	173.57	1515220.0
2019-03-06 12:30:00	QQQ	ETF	173.5742	173.86	173.43	173.4799	1325601.0

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

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