PREVIEW / etf_30min / 2019-03-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-26.parquet
  size:    494 KB
  rows:    17,256

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-26 04:00:00	SPY	ETF	279.98	280.18	279.81	279.86	11362.0
2019-03-26 04:30:00	SPY	ETF	279.94	279.94	279.66	279.66	3918.0
2019-03-26 05:00:00	SPY	ETF	279.69	280.12	279.68	280.05	41204.0
2019-03-26 05:30:00	SPY	ETF	280.14	280.44	280.05	280.37	11739.0
2019-03-26 06:00:00	SPY	ETF	280.39	280.7	280.39	280.7	7907.0
2019-03-26 06:30:00	SPY	ETF	280.7	280.8	280.57	280.74	37924.0
2019-03-26 07:00:00	SPY	ETF	280.73	280.88	280.66	280.82	80496.0
2019-03-26 07:30:00	SPY	ETF	280.83	280.85	280.62	280.77	54542.0
2019-03-26 08:00:00	SPY	ETF	280.74	281.04	279.68	280.8	255388.0
2019-03-26 08:30:00	SPY	ETF	280.82	280.82	279.04	280.53	381927.0
2019-03-26 09:00:00	SPY	ETF	280.54	280.99	280.54	280.97	380619.0
2019-03-26 09:30:00	SPY	ETF	280.99	281.98	280.97	281.97	9006645.0
2019-03-26 10:00:00	SPY	ETF	281.98	282.04	281.38	281.68	4730795.0
2019-03-26 10:30:00	SPY	ETF	281.7	282.18	281.22	282.09	4110818.0
2019-03-26 11:00:00	SPY	ETF	282.09	282.18	281.385	281.5301	5335466.0
2019-03-26 11:30:00	SPY	ETF	281.53	281.87	280.8	281.0752	3862473.0
2019-03-26 12:00:00	SPY	ETF	281.09	281.34	280.65	280.73	3472708.0
2019-03-26 12:30:00	SPY	ETF	280.73	280.86	280.22	280.62	2953492.0
2019-03-26 13:00:00	SPY	ETF	280.61	280.93	280.5	280.54	1940642.0
2019-03-26 13:30:00	SPY	ETF	280.55	280.565	279.92	279.98	2880699.0
2019-03-26 14:00:00	SPY	ETF	279.975	280.14	279.73	279.775	3529807.0
2019-03-26 14:30:00	SPY	ETF	279.77	280.33	279.56	280.3	3378727.0
2019-03-26 15:00:00	SPY	ETF	280.3	280.6	279.9692	280.03	4218144.0
2019-03-26 15:30:00	SPY	ETF	280.0223	281.09	279.86	281.03	8987541.0
2019-03-26 16:00:00	SPY	ETF	281.02	281.12	280.78	281.03	6460684.0
2019-03-26 16:30:00	SPY	ETF	281.01	281.14	280.95	281.06	549262.0
2019-03-26 17:00:00	SPY	ETF	281.07	281.14	281.02	281.08	44456.0
2019-03-26 17:30:00	SPY	ETF	281.06	281.07	281.02	281.05	69705.0
2019-03-26 18:00:00	SPY	ETF	281.05	281.05	280.72	280.75	88871.0
2019-03-26 18:30:00	SPY	ETF	280.76	280.88	280.72	280.75	19147.0
2019-03-26 19:00:00	SPY	ETF	280.74	280.74	280.63	280.65	37257.0
2019-03-26 19:30:00	SPY	ETF	280.64	281.0	280.62	280.98	31229.0
2019-03-26 04:00:00	QQQ	ETF	178.85	178.85	178.58	178.63	3800.0
2019-03-26 04:30:00	QQQ	ETF	178.76	178.76	178.55	178.55	1200.0
2019-03-26 05:00:00	QQQ	ETF	178.64	178.94	178.64	178.82	1700.0
2019-03-26 05:30:00	QQQ	ETF	178.82	179.08	178.76	179.06	18300.0
2019-03-26 06:00:00	QQQ	ETF	179.08	179.24	179.02	179.24	14286.0
2019-03-26 06:30:00	QQQ	ETF	179.19	179.29	179.12	179.26	45477.0
2019-03-26 07:00:00	QQQ	ETF	179.26	179.43	179.23	179.31	153942.0
2019-03-26 07:30:00	QQQ	ETF	179.33	179.41	179.22	179.35	54945.0
2019-03-26 08:00:00	QQQ	ETF	179.3699	179.62	178.61	179.43	126118.0
2019-03-26 08:30:00	QQQ	ETF	179.4	179.45	178.22	179.27	255682.0
2019-03-26 09:00:00	QQQ	ETF	179.2993	179.68	179.29	179.55	94191.0
2019-03-26 09:30:00	QQQ	ETF	179.58	180.55	179.56	180.55	4626232.0
2019-03-26 10:00:00	QQQ	ETF	180.55	180.69	179.79	180.0	3176679.0
2019-03-26 10:30:00	QQQ	ETF	180.02	180.37	179.59	180.2452	2571237.0
2019-03-26 11:00:00	QQQ	ETF	180.25	180.34	179.6873	179.84	1641208.0
2019-03-26 11:30:00	QQQ	ETF	179.84	180.06	179.27	179.51	1697928.0
2019-03-26 12:00:00	QQQ	ETF	179.54	179.8	179.26	179.33	1345900.0
2019-03-26 12:30:00	QQQ	ETF	179.33	179.46	178.99	179.35	1974440.0

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

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