PREVIEW / etf_30min / 2018-10-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-19.parquet
  size:    482 KB
  rows:    16,500

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-19 04:00:00	SPY	ETF	276.96	276.96	276.58	276.58	12617.0
2018-10-19 04:30:00	SPY	ETF	276.55	277.04	276.55	276.9	37682.0
2018-10-19 05:00:00	SPY	ETF	276.96	277.05	276.83	276.95	22054.0
2018-10-19 05:30:00	SPY	ETF	276.96	277.2	276.7	276.74	52681.0
2018-10-19 06:00:00	SPY	ETF	276.76	277.2	276.64	277.2	24966.0
2018-10-19 06:30:00	SPY	ETF	277.19	277.29	276.87	276.92	39555.0
2018-10-19 07:00:00	SPY	ETF	276.89	277.71	276.89	277.66	484670.0
2018-10-19 07:30:00	SPY	ETF	277.65	277.72	277.45	277.55	245719.0
2018-10-19 08:00:00	SPY	ETF	277.55	277.99	276.92	277.6	425544.0
2018-10-19 08:30:00	SPY	ETF	277.58	277.6	277.22	277.51	370151.0
2018-10-19 09:00:00	SPY	ETF	277.5	277.76	277.11	277.11	738645.0
2018-10-19 09:30:00	SPY	ETF	277.13	278.79	277.09	278.44	12570166.0
2018-10-19 10:00:00	SPY	ETF	278.45	279.3	278.36	278.53	12787229.0
2018-10-19 10:30:00	SPY	ETF	278.54	279.05	278.2	278.7175	11337765.0
2018-10-19 11:00:00	SPY	ETF	278.71	278.9964	277.9	277.93	5810639.0
2018-10-19 11:30:00	SPY	ETF	277.94	278.13	277.24	277.98	7269814.0
2018-10-19 12:00:00	SPY	ETF	277.98	278.17	276.41	276.66	8912518.0
2018-10-19 12:30:00	SPY	ETF	276.66	277.09	275.98	276.86	8149894.0
2018-10-19 13:00:00	SPY	ETF	276.86	277.5	276.175	277.46	5199420.0
2018-10-19 13:30:00	SPY	ETF	277.47	277.61	276.7	276.73	4417155.0
2018-10-19 14:00:00	SPY	ETF	276.73	276.73	275.47	276.47	8027797.0
2018-10-19 14:30:00	SPY	ETF	276.47	276.95	276.22	276.43	4943679.0
2018-10-19 15:00:00	SPY	ETF	276.43	277.02	275.89	276.94	8677942.0
2018-10-19 15:30:00	SPY	ETF	276.93	277.11	276.13	276.19	18680742.0
2018-10-19 16:00:00	SPY	ETF	276.16	276.3605	275.7	276.0	15203988.0
2018-10-19 16:30:00	SPY	ETF	276.01	276.1	275.87	276.01	2472381.0
2018-10-19 17:00:00	SPY	ETF	276.0	276.25	275.9	275.9	927016.0
2018-10-19 17:30:00	SPY	ETF	275.86	275.99	275.77	275.8	61368.0
2018-10-19 18:00:00	SPY	ETF	275.8	277.15	275.8	276.19	315528.0
2018-10-19 18:30:00	SPY	ETF	276.19	276.63	276.17	276.3	87597.0
2018-10-19 19:00:00	SPY	ETF	276.26	276.27	276.2	276.25	14355.0
2018-10-19 19:30:00	SPY	ETF	276.25	276.29	276.21	276.21	20029.0
2018-10-19 04:00:00	QQQ	ETF	173.94	174.03	173.58	173.67	16430.0
2018-10-19 04:30:00	QQQ	ETF	173.54	173.85	173.51	173.85	5510.0
2018-10-19 05:00:00	QQQ	ETF	173.89	173.96	173.89	173.92	3950.0
2018-10-19 05:30:00	QQQ	ETF	174.09	174.21	173.8	173.85	32427.0
2018-10-19 06:00:00	QQQ	ETF	173.83	174.16	173.82	174.16	6600.0
2018-10-19 06:30:00	QQQ	ETF	174.23	174.34	174.02	174.07	64155.0
2018-10-19 07:00:00	QQQ	ETF	174.05	174.69	174.05	174.68	122950.0
2018-10-19 07:30:00	QQQ	ETF	174.64	174.71	174.47	174.61	93536.0
2018-10-19 08:00:00	QQQ	ETF	173.18	174.86	173.18	174.55	155216.0
2018-10-19 08:30:00	QQQ	ETF	174.54	174.57	174.25	174.49	222669.0
2018-10-19 09:00:00	QQQ	ETF	174.5	174.75	174.295	174.42	534883.0
2018-10-19 09:30:00	QQQ	ETF	174.39	175.8	174.34	175.41	6802046.0
2018-10-19 10:00:00	QQQ	ETF	175.41	176.07	175.275	175.5	5260406.0
2018-10-19 10:30:00	QQQ	ETF	175.5	175.96	175.0101	175.3699	3506424.0
2018-10-19 11:00:00	QQQ	ETF	175.37	175.66	174.6	174.61	2995784.0
2018-10-19 11:30:00	QQQ	ETF	174.62	174.79	173.9	174.46	5492207.0
2018-10-19 12:00:00	QQQ	ETF	174.44	174.6	172.86	173.15	5878042.0
2018-10-19 12:30:00	QQQ	ETF	173.15	173.75	172.57	173.56	5510119.0

> showing 50 of 16,500 rows — these rows as CSV

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