PREVIEW / etf_30min / 2019-06-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-19.parquet
  size:    492 KB
  rows:    17,468

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-06-19 04:00:00	SPY	ETF	292.59	292.73	292.48	292.57	11393.0
2019-06-19 04:30:00	SPY	ETF	292.5	292.5	292.19	292.32	2954.0
2019-06-19 05:00:00	SPY	ETF	292.33	292.54	292.32	292.32	3178.0
2019-06-19 05:30:00	SPY	ETF	292.41	292.62	292.41	292.57	2683.0
2019-06-19 06:00:00	SPY	ETF	292.49	292.7	292.48	292.7	18247.0
2019-06-19 06:30:00	SPY	ETF	292.77	292.77	292.58	292.67	5688.0
2019-06-19 07:00:00	SPY	ETF	292.67	292.68	292.46	292.51	39460.0
2019-06-19 07:30:00	SPY	ETF	292.52	292.69	292.48	292.69	18447.0
2019-06-19 08:00:00	SPY	ETF	292.67	292.68	292.54	292.65	30372.0
2019-06-19 08:30:00	SPY	ETF	292.64	292.8	292.58	292.66	202801.0
2019-06-19 09:00:00	SPY	ETF	292.67	292.67	292.52	292.53	180285.0
2019-06-19 09:30:00	SPY	ETF	292.55	292.7	292.04	292.58	4904276.0
2019-06-19 10:00:00	SPY	ETF	292.58	292.65	292.115	292.17	6597256.0
2019-06-19 10:30:00	SPY	ETF	292.16	292.27	292.04	292.199	3492501.0
2019-06-19 11:00:00	SPY	ETF	292.2	292.38	292.16	292.37	2314025.0
2019-06-19 11:30:00	SPY	ETF	292.365	292.49	292.18	292.37	1887658.0
2019-06-19 12:00:00	SPY	ETF	292.37	292.39	292.16	292.22	1328708.0
2019-06-19 12:30:00	SPY	ETF	292.22	292.245	292.11	292.17	2421826.0
2019-06-19 13:00:00	SPY	ETF	292.16	292.19	291.89	292.065	3833297.0
2019-06-19 13:30:00	SPY	ETF	292.07	292.3	291.93	292.18	3949483.0
2019-06-19 14:00:00	SPY	ETF	292.19	293.5	291.47	292.63	13047666.0
2019-06-19 14:30:00	SPY	ETF	292.64	293.31	292.31	292.87	6590534.0
2019-06-19 15:00:00	SPY	ETF	292.8625	293.49	292.8	293.24	5785458.0
2019-06-19 15:30:00	SPY	ETF	293.24	293.65	292.88	293.05	11008249.0
2019-06-19 16:00:00	SPY	ETF	293.06	293.36	292.99	293.22	9159682.0
2019-06-19 16:30:00	SPY	ETF	293.22	293.28	293.1	293.14	133258.0
2019-06-19 17:00:00	SPY	ETF	293.06	293.11	292.94	292.95	159145.0
2019-06-19 17:30:00	SPY	ETF	292.99	293.07	292.94	292.98	39923.0
2019-06-19 18:00:00	SPY	ETF	293.0	293.37	293.0	293.29	126298.0
2019-06-19 18:30:00	SPY	ETF	293.3	293.72	293.26	293.68	51457.0
2019-06-19 19:00:00	SPY	ETF	293.65	293.84	293.63	293.81	36126.0
2019-06-19 19:30:00	SPY	ETF	293.82	294.22	293.79	294.06	76593.0
2019-06-19 04:00:00	QQQ	ETF	186.69	186.76	186.65	186.76	8156.0
2019-06-19 04:30:00	QQQ	ETF	186.77	186.77	186.49	186.55	8585.0
2019-06-19 05:00:00	QQQ	ETF	186.55	186.66	186.38	186.45	6795.0
2019-06-19 05:30:00	QQQ	ETF	186.51	186.65	186.51	186.63	600.0
2019-06-19 06:00:00	QQQ	ETF	186.59	186.68	186.51	186.68	8408.0
2019-06-19 06:30:00	QQQ	ETF	186.68	186.78	186.62	186.69	6605.0
2019-06-19 07:00:00	QQQ	ETF	186.71	186.71	186.52	186.57	24944.0
2019-06-19 07:30:00	QQQ	ETF	186.59	186.76	186.58	186.76	15600.0
2019-06-19 08:00:00	QQQ	ETF	186.66	186.8	186.53	186.78	47543.0
2019-06-19 08:30:00	QQQ	ETF	186.73	186.87	186.72	186.81	41580.0
2019-06-19 09:00:00	QQQ	ETF	186.8	186.83	186.7	186.73	51118.0
2019-06-19 09:30:00	QQQ	ETF	186.73	186.85	185.75	186.25	2588246.0
2019-06-19 10:00:00	QQQ	ETF	186.28	186.34	185.98	186.0	2145330.0
2019-06-19 10:30:00	QQQ	ETF	186.01	186.19	185.9	186.04	697963.0
2019-06-19 11:00:00	QQQ	ETF	186.04	186.345	186.03	186.34	693427.0
2019-06-19 11:30:00	QQQ	ETF	186.345	186.38	186.18	186.3	699559.0
2019-06-19 12:00:00	QQQ	ETF	186.29	186.34	186.0711	186.22	586427.0
2019-06-19 12:30:00	QQQ	ETF	186.23	186.24	186.09	186.17	358151.0

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

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