PREVIEW / etf_30min / 2019-02-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-07.parquet
  size:    506 KB
  rows:    17,677

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-02-07 04:00:00	SPY	ETF	272.11	272.16	272.04	272.09	11255.0
2019-02-07 04:30:00	SPY	ETF	272.09	272.17	272.02	272.17	1953.0
2019-02-07 05:00:00	SPY	ETF	272.05	272.05	271.36	271.36	15244.0
2019-02-07 05:30:00	SPY	ETF	271.27	271.54	271.22	271.4	41010.0
2019-02-07 06:00:00	SPY	ETF	271.34	271.45	270.8	271.04	116696.0
2019-02-07 06:30:00	SPY	ETF	271.06	271.13	270.72	270.92	125830.0
2019-02-07 07:00:00	SPY	ETF	270.94	271.28	270.82	271.14	253880.0
2019-02-07 07:30:00	SPY	ETF	271.18	271.18	270.9	270.9	101848.0
2019-02-07 08:00:00	SPY	ETF	270.95	272.07	270.65	270.97	418924.0
2019-02-07 08:30:00	SPY	ETF	270.98	272.74	270.95	271.18	315072.0
2019-02-07 09:00:00	SPY	ETF	271.17	271.26	270.92	270.93	265804.0
2019-02-07 09:30:00	SPY	ETF	270.94	271.08	270.38	270.75	8969478.0
2019-02-07 10:00:00	SPY	ETF	270.755	271.4	270.28	271.29	5684736.0
2019-02-07 10:30:00	SPY	ETF	271.29	271.55	269.84	269.88	6391532.0
2019-02-07 11:00:00	SPY	ETF	269.88	270.07	269.17	269.32	6409177.0
2019-02-07 11:30:00	SPY	ETF	269.31	269.33	268.49	268.56	10474873.0
2019-02-07 12:00:00	SPY	ETF	268.54	269.23	268.29	268.9317	5396234.0
2019-02-07 12:30:00	SPY	ETF	268.94	269.29	268.31	268.57	4256788.0
2019-02-07 13:00:00	SPY	ETF	268.56	269.51	268.52	269.3349	3975236.0
2019-02-07 13:30:00	SPY	ETF	269.34	269.73	269.22	269.43	4342351.0
2019-02-07 14:00:00	SPY	ETF	269.42	269.55	268.67	269.55	6540149.0
2019-02-07 14:30:00	SPY	ETF	269.56	269.69	269.13	269.31	4118416.0
2019-02-07 15:00:00	SPY	ETF	269.3	269.5599	269.04	269.4275	5968275.0
2019-02-07 15:30:00	SPY	ETF	269.42	270.25	269.07	270.19	13477642.0
2019-02-07 16:00:00	SPY	ETF	270.18	270.31	269.21	270.13	6024032.0
2019-02-07 16:30:00	SPY	ETF	270.13	270.15	269.96	270.03	328007.0
2019-02-07 17:00:00	SPY	ETF	270.04	270.14	269.87	269.9	156073.0
2019-02-07 17:30:00	SPY	ETF	269.9	269.95	269.75	269.89	123188.0
2019-02-07 18:00:00	SPY	ETF	269.89	269.99	269.61	269.64	107113.0
2019-02-07 18:30:00	SPY	ETF	269.67	269.69	269.44	269.53	161362.0
2019-02-07 19:00:00	SPY	ETF	269.45	269.7	269.36	269.67	30463.0
2019-02-07 19:30:00	SPY	ETF	269.59	269.6	269.41	269.46	31364.0
2019-02-07 04:00:00	QQQ	ETF	169.87	169.96	169.84	169.85	23271.0
2019-02-07 04:30:00	QQQ	ETF	169.85	170.0	169.81	170.0	16601.0
2019-02-07 05:00:00	QQQ	ETF	169.97	170.02	169.35	169.38	32392.0
2019-02-07 05:30:00	QQQ	ETF	169.4	169.55	169.3	169.46	46966.0
2019-02-07 06:00:00	QQQ	ETF	169.41	169.49	169.16	169.31	26038.0
2019-02-07 06:30:00	QQQ	ETF	169.29	169.38	169.16	169.27	22958.0
2019-02-07 07:00:00	QQQ	ETF	169.29	169.47	169.2	169.42	75124.0
2019-02-07 07:30:00	QQQ	ETF	169.47	169.47	169.21	169.24	132217.0
2019-02-07 08:00:00	QQQ	ETF	169.22	169.88	169.02	169.2	248333.0
2019-02-07 08:30:00	QQQ	ETF	169.18	169.34	169.16	169.34	149257.0
2019-02-07 09:00:00	QQQ	ETF	169.29	169.36	169.0	169.04	209246.0
2019-02-07 09:30:00	QQQ	ETF	169.04	169.05	168.33	168.82	4776227.0
2019-02-07 10:00:00	QQQ	ETF	168.83	169.32	168.5	169.25	2430350.0
2019-02-07 10:30:00	QQQ	ETF	169.25	169.4499	168.25	168.2799	2740691.0
2019-02-07 11:00:00	QQQ	ETF	168.27	168.535	167.87	167.94	2640993.0
2019-02-07 11:30:00	QQQ	ETF	167.95	167.955	167.21	167.22	4950450.0
2019-02-07 12:00:00	QQQ	ETF	167.22	167.73	166.95	167.49	2689965.0
2019-02-07 12:30:00	QQQ	ETF	167.49	167.78	167.03	167.24	2193134.0

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

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