PREVIEW / etf_30min / 2018-10-25

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-25.parquet
  size:    512 KB
  rows:    17,729

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
2018-10-25 04:00:00	SPY	ETF	267.43	267.75	267.27	267.62	105839.0
2018-10-25 04:30:00	SPY	ETF	267.65	267.75	267.2	267.68	61871.0
2018-10-25 05:00:00	SPY	ETF	267.66	268.32	267.55	268.32	130475.0
2018-10-25 05:30:00	SPY	ETF	268.37	268.67	268.19	268.57	79358.0
2018-10-25 06:00:00	SPY	ETF	268.65	268.65	267.75	267.75	110374.0
2018-10-25 06:30:00	SPY	ETF	267.75	268.07	267.61	268.06	149018.0
2018-10-25 07:00:00	SPY	ETF	268.0	268.22	267.66	267.98	283506.0
2018-10-25 07:30:00	SPY	ETF	268.03	268.19	267.33	267.49	414935.0
2018-10-25 08:00:00	SPY	ETF	267.97	268.18	265.91	267.76	730728.0
2018-10-25 08:30:00	SPY	ETF	267.79	268.06	267.0	267.25	1048144.0
2018-10-25 09:00:00	SPY	ETF	267.22	267.42	266.76	267.38	1098527.0
2018-10-25 09:30:00	SPY	ETF	267.38	268.3	266.23	268.09	16551847.0
2018-10-25 10:00:00	SPY	ETF	268.09	269.18	267.77	268.7	10682841.0
2018-10-25 10:30:00	SPY	ETF	268.71	269.44	268.51	268.67	10044105.0
2018-10-25 11:00:00	SPY	ETF	268.66	270.0	267.94	269.9	9193631.0
2018-10-25 11:30:00	SPY	ETF	269.89	270.1	269.14	269.44	6655299.0
2018-10-25 12:00:00	SPY	ETF	269.44	269.67	268.655	268.98	7027582.0
2018-10-25 12:30:00	SPY	ETF	268.99	269.8	268.81	269.58	4828130.0
2018-10-25 13:00:00	SPY	ETF	269.59	269.8	268.75	269.44	4111568.0
2018-10-25 13:30:00	SPY	ETF	269.44	270.27	269.35	269.81	5590998.0
2018-10-25 14:00:00	SPY	ETF	269.8	270.92	269.54	270.74	8386571.0
2018-10-25 14:30:00	SPY	ETF	270.73	271.8	270.67	271.2801	7588358.0
2018-10-25 15:00:00	SPY	ETF	271.285	271.81	271.06	271.37	8419584.0
2018-10-25 15:30:00	SPY	ETF	271.37	271.63	269.56	270.14	18057239.0
2018-10-25 16:00:00	SPY	ETF	270.11	271.0	267.89	268.3	12343629.0
2018-10-25 16:30:00	SPY	ETF	268.21	268.47	267.29	267.55	1607848.0
2018-10-25 17:00:00	SPY	ETF	267.56	270.08	265.1418	266.91	655394.0
2018-10-25 17:30:00	SPY	ETF	266.91	270.08	266.88	267.26	246738.0
2018-10-25 18:00:00	SPY	ETF	267.26	267.38	266.21	266.98	235004.0
2018-10-25 18:30:00	SPY	ETF	267.0	267.47	266.99	267.4	123152.0
2018-10-25 19:00:00	SPY	ETF	267.39	267.49	267.15	267.44	44174.0
2018-10-25 19:30:00	SPY	ETF	267.36	267.36	267.0	267.05	38569.0
2018-10-25 20:00:00	SPY	ETF	270.08	270.08	267.03	267.05	520.0
2018-10-25 04:00:00	QQQ	ETF	167.76	168.31	167.66	168.18	119729.0
2018-10-25 04:30:00	QQQ	ETF	168.16	168.4	167.88	168.27	61262.0
2018-10-25 05:00:00	QQQ	ETF	168.3	168.79	168.25	168.76	110143.0
2018-10-25 05:30:00	QQQ	ETF	168.79	169.36	168.71	169.36	151173.0
2018-10-25 06:00:00	QQQ	ETF	169.36	169.36	168.62	168.64	180936.0
2018-10-25 06:30:00	QQQ	ETF	168.65	168.75	168.47	168.64	59540.0
2018-10-25 07:00:00	QQQ	ETF	168.62	168.62	168.22	168.31	213621.0
2018-10-25 07:30:00	QQQ	ETF	168.36	168.58	167.92	168.14	127151.0
2018-10-25 08:00:00	QQQ	ETF	168.12	168.73	166.8	168.3	304139.0
2018-10-25 08:30:00	QQQ	ETF	168.28	168.46	167.57	167.74	427285.0
2018-10-25 09:00:00	QQQ	ETF	167.72	168.01	167.36	168.0	595555.0
2018-10-25 09:30:00	QQQ	ETF	167.99	169.22	167.16	169.08	11256597.0
2018-10-25 10:00:00	QQQ	ETF	169.08	170.12	168.66	169.57	7959495.0
2018-10-25 10:30:00	QQQ	ETF	169.57	170.189	169.34	169.46	4079665.0
2018-10-25 11:00:00	QQQ	ETF	169.47	170.39	168.96	170.2	4116483.0
2018-10-25 11:30:00	QQQ	ETF	170.2	170.51	169.72	170.07	2321785.0
2018-10-25 12:00:00	QQQ	ETF	170.08	170.1901	169.29	169.615	2698342.0

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

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