PREVIEW / etf_30min / 2019-03-29

all etf 30-min files

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

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-29 04:00:00	SPY	ETF	281.47	281.59	281.31	281.4	5658.0
2019-03-29 04:30:00	SPY	ETF	281.42	281.42	281.23	281.23	6114.0
2019-03-29 05:00:00	SPY	ETF	281.24	281.37	281.22	281.37	480.0
2019-03-29 05:30:00	SPY	ETF	281.25	281.32	281.25	281.32	1712.0
2019-03-29 06:00:00	SPY	ETF	281.25	281.31	281.04	281.12	10160.0
2019-03-29 06:30:00	SPY	ETF	281.05	281.5	281.03	281.5	17311.0
2019-03-29 07:00:00	SPY	ETF	281.52	282.24	281.48	282.1	248794.0
2019-03-29 07:30:00	SPY	ETF	282.13	282.16	282.0	282.07	101314.0
2019-03-29 08:00:00	SPY	ETF	281.94	282.23	281.33	282.0	198283.0
2019-03-29 08:30:00	SPY	ETF	281.99	282.25	281.9	282.2	265168.0
2019-03-29 09:00:00	SPY	ETF	282.19	282.5	282.19	282.37	426843.0
2019-03-29 09:30:00	SPY	ETF	282.39	282.56	281.62	282.0	6141983.0
2019-03-29 10:00:00	SPY	ETF	282.0	282.219	281.75	282.15	4388310.0
2019-03-29 10:30:00	SPY	ETF	282.155	282.17	281.14	281.46	4507529.0
2019-03-29 11:00:00	SPY	ETF	281.45	281.99	281.44	281.97	3115546.0
2019-03-29 11:30:00	SPY	ETF	281.965	282.31	281.86	281.88	2722899.0
2019-03-29 12:00:00	SPY	ETF	281.89	281.955	281.44	281.87	2604481.0
2019-03-29 12:30:00	SPY	ETF	281.87	282.14	281.75	282.0175	1909566.0
2019-03-29 13:00:00	SPY	ETF	282.02	282.08	281.65	281.935	1928404.0
2019-03-29 13:30:00	SPY	ETF	281.93	282.1	281.73	281.95	1953741.0
2019-03-29 14:00:00	SPY	ETF	281.9478	282.26	281.9	282.2298	4905327.0
2019-03-29 14:30:00	SPY	ETF	282.21	282.69	281.92	282.58	4863113.0
2019-03-29 15:00:00	SPY	ETF	282.59	282.8	282.04	282.24	4541254.0
2019-03-29 15:30:00	SPY	ETF	282.24	282.84	282.06	282.62	15149910.0
2019-03-29 16:00:00	SPY	ETF	282.62	282.83	280.7765	282.73	13631622.0
2019-03-29 16:30:00	SPY	ETF	282.73	282.83	282.4	282.75	3058783.0
2019-03-29 17:00:00	SPY	ETF	282.74	282.75	282.45	282.47	1103226.0
2019-03-29 17:30:00	SPY	ETF	282.47	282.5	282.145	282.47	269324.0
2019-03-29 18:00:00	SPY	ETF	282.44	282.49	282.4	282.46	70643.0
2019-03-29 18:30:00	SPY	ETF	282.49	282.51	282.45	282.48	3269.0
2019-03-29 19:00:00	SPY	ETF	282.49	282.58	282.49	282.58	7632.0
2019-03-29 19:30:00	SPY	ETF	282.57	282.6	282.54	282.58	15910.0
2019-03-29 04:00:00	QQQ	ETF	179.12	179.22	178.98	179.06	9442.0
2019-03-29 04:30:00	QQQ	ETF	179.01	179.01	178.89	178.91	2500.0
2019-03-29 05:00:00	QQQ	ETF	178.84	178.92	178.77	178.89	7300.0
2019-03-29 05:30:00	QQQ	ETF	178.88	178.91	178.83	178.88	1800.0
2019-03-29 06:00:00	QQQ	ETF	178.83	178.83	178.65	178.65	4650.0
2019-03-29 06:30:00	QQQ	ETF	178.72	178.94	178.64	178.92	23218.0
2019-03-29 07:00:00	QQQ	ETF	178.93	179.39	178.92	179.25	135939.0
2019-03-29 07:30:00	QQQ	ETF	179.3	179.35	179.25	179.28	48896.0
2019-03-29 08:00:00	QQQ	ETF	179.28	179.43	178.94	179.26	90663.0
2019-03-29 08:30:00	QQQ	ETF	179.26	179.46	179.17	179.4	133611.0
2019-03-29 09:00:00	QQQ	ETF	179.43	179.64	179.41	179.62	189066.0
2019-03-29 09:30:00	QQQ	ETF	179.61	179.76	178.9564	179.22	3071508.0
2019-03-29 10:00:00	QQQ	ETF	179.22	179.54	179.16	179.4699	1651821.0
2019-03-29 10:30:00	QQQ	ETF	179.47	179.49	178.59	178.855	2285246.0
2019-03-29 11:00:00	QQQ	ETF	178.84	179.43	178.84	179.43	1585704.0
2019-03-29 11:30:00	QQQ	ETF	179.43	179.64	179.27	179.28	1256035.0
2019-03-29 12:00:00	QQQ	ETF	179.28	179.3385	178.99	179.29	1267936.0
2019-03-29 12:30:00	QQQ	ETF	179.29	179.47	179.16	179.37	871745.0

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

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