PREVIEW / etf_30min / 2019-09-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-06.parquet
  size:    500 KB
  rows:    17,440

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-09-06 04:00:00	SPY	ETF	298.12	298.12	298.0	298.07	2756.0
2019-09-06 04:30:00	SPY	ETF	298.12	298.14	298.03	298.03	5500.0
2019-09-06 05:00:00	SPY	ETF	298.25	298.66	298.25	298.55	19435.0
2019-09-06 05:30:00	SPY	ETF	298.3	298.55	298.01	298.01	9118.0
2019-09-06 06:00:00	SPY	ETF	298.0	298.13	297.89	298.1	14509.0
2019-09-06 06:30:00	SPY	ETF	298.17	298.33	298.05	298.22	31908.0
2019-09-06 07:00:00	SPY	ETF	298.24	298.4	298.18	298.3	93108.0
2019-09-06 07:30:00	SPY	ETF	298.3	298.64	298.3	298.6	339763.0
2019-09-06 08:00:00	SPY	ETF	298.2699	298.89	297.88	298.73	325202.0
2019-09-06 08:30:00	SPY	ETF	298.52	298.98	298.0	298.26	1370144.0
2019-09-06 09:00:00	SPY	ETF	298.31	298.55	298.19	298.19	627842.0
2019-09-06 09:30:00	SPY	ETF	298.17	298.34	297.42	297.95	7240759.0
2019-09-06 10:00:00	SPY	ETF	297.96	298.42	297.74	298.41	3348180.0
2019-09-06 10:30:00	SPY	ETF	298.42	298.61	298.2	298.42	2343087.0
2019-09-06 11:00:00	SPY	ETF	298.43	298.52	298.28	298.39	1712396.0
2019-09-06 11:30:00	SPY	ETF	298.39	298.46	298.11	298.22	1955394.0
2019-09-06 12:00:00	SPY	ETF	298.225	298.44	298.16	298.36	2327384.0
2019-09-06 12:30:00	SPY	ETF	298.37	298.39	297.77	298.21	2957050.0
2019-09-06 13:00:00	SPY	ETF	298.21	298.65	298.18	298.63	2193695.0
2019-09-06 13:30:00	SPY	ETF	298.62	298.76	298.53	298.6249	1745387.0
2019-09-06 14:00:00	SPY	ETF	298.63	298.65	298.43	298.5316	2174244.0
2019-09-06 14:30:00	SPY	ETF	298.53	298.59	298.32	298.41	1922108.0
2019-09-06 15:00:00	SPY	ETF	298.4	298.605	298.32	298.59	3216240.0
2019-09-06 15:30:00	SPY	ETF	298.59	298.72	297.88	298.07	8775834.0
2019-09-06 16:00:00	SPY	ETF	298.09	298.35	297.99	298.31	3774970.0
2019-09-06 16:30:00	SPY	ETF	298.31	298.49	298.05	298.47	158214.0
2019-09-06 17:00:00	SPY	ETF	298.47	298.53	298.05	298.49	115723.0
2019-09-06 17:30:00	SPY	ETF	298.5	298.72	298.05	298.66	101021.0
2019-09-06 18:00:00	SPY	ETF	298.63	298.7	298.6	298.68	18962.0
2019-09-06 18:30:00	SPY	ETF	298.65	298.68	298.61	298.61	3500.0
2019-09-06 19:00:00	SPY	ETF	298.61	298.6501	298.58	298.65	6847.0
2019-09-06 19:30:00	SPY	ETF	298.66	298.66	298.59	298.6	39538.0
2019-09-06 04:00:00	QQQ	ETF	191.94	191.96	191.88	191.91	3850.0
2019-09-06 04:30:00	QQQ	ETF	191.94	191.94	191.94	191.94	100.0
2019-09-06 05:00:00	QQQ	ETF	191.99	192.35	191.97	192.34	14729.0
2019-09-06 05:30:00	QQQ	ETF	192.15	192.24	191.81	191.81	30589.0
2019-09-06 06:00:00	QQQ	ETF	191.72	191.92	191.72	191.92	4395.0
2019-09-06 06:30:00	QQQ	ETF	191.93	192.0	191.8	191.98	18564.0
2019-09-06 07:00:00	QQQ	ETF	191.99	192.12	191.94	192.0	88179.0
2019-09-06 07:30:00	QQQ	ETF	192.04	192.24	192.04	192.18	136372.0
2019-09-06 08:00:00	QQQ	ETF	192.03	192.37	191.71	192.2	129361.0
2019-09-06 08:30:00	QQQ	ETF	192.05	192.51	191.73	191.9	300355.0
2019-09-06 09:00:00	QQQ	ETF	191.91	192.18	191.9	192.01	150020.0
2019-09-06 09:30:00	QQQ	ETF	192.03	192.1	191.2299	191.46	2882893.0
2019-09-06 10:00:00	QQQ	ETF	191.48	191.77	191.29	191.77	1055573.0
2019-09-06 10:30:00	QQQ	ETF	191.78	192.1	191.6	191.94	976126.0
2019-09-06 11:00:00	QQQ	ETF	191.94	192.05	191.79	191.84	710498.0
2019-09-06 11:30:00	QQQ	ETF	191.85	191.905	191.62	191.66	806442.0
2019-09-06 12:00:00	QQQ	ETF	191.66	191.79	191.62	191.74	427106.0
2019-09-06 12:30:00	QQQ	ETF	191.75	191.76	191.17	191.64	1031259.0

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

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