PREVIEW / etf_30min / 2019-02-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-27.parquet
  size:    487 KB
  rows:    17,008

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-27 04:00:00	SPY	ETF	278.1	278.22	278.01	278.21	7854.0
2019-02-27 04:30:00	SPY	ETF	278.28	278.28	278.15	278.27	1275.0
2019-02-27 05:00:00	SPY	ETF	278.22	278.31	278.17	278.24	2570.0
2019-02-27 05:30:00	SPY	ETF	278.35	278.52	278.35	278.45	6257.0
2019-02-27 06:00:00	SPY	ETF	278.49	278.55	278.41	278.43	10621.0
2019-02-27 06:30:00	SPY	ETF	278.52	278.57	278.45	278.48	24966.0
2019-02-27 07:00:00	SPY	ETF	278.48	278.64	278.44	278.6	87742.0
2019-02-27 07:30:00	SPY	ETF	278.58	278.71	278.58	278.6	44802.0
2019-02-27 08:00:00	SPY	ETF	278.6	279.22	278.23	278.54	99581.0
2019-02-27 08:30:00	SPY	ETF	278.54	278.72	278.46	278.46	114828.0
2019-02-27 09:00:00	SPY	ETF	278.48	278.71	278.45	278.52	457773.0
2019-02-27 09:30:00	SPY	ETF	278.52	279.23	278.52	278.75	4389677.0
2019-02-27 10:00:00	SPY	ETF	278.735	278.87	277.48	277.83	8968169.0
2019-02-27 10:30:00	SPY	ETF	277.83	278.3	277.68	278.105	5484036.0
2019-02-27 11:00:00	SPY	ETF	278.1	278.64	278.0	278.5	3378439.0
2019-02-27 11:30:00	SPY	ETF	278.49	278.79	278.4	278.66	2731516.0
2019-02-27 12:00:00	SPY	ETF	278.665	279.0	278.6375	278.88	2098218.0
2019-02-27 12:30:00	SPY	ETF	278.88	279.08	278.83	278.88	1666043.0
2019-02-27 13:00:00	SPY	ETF	278.8701	279.46	278.87	279.3	2884678.0
2019-02-27 13:30:00	SPY	ETF	279.295	279.33	279.0	279.18	2899484.0
2019-02-27 14:00:00	SPY	ETF	279.185	279.42	279.06	279.24	1894173.0
2019-02-27 14:30:00	SPY	ETF	279.25	279.59	279.16	279.29	2602690.0
2019-02-27 15:00:00	SPY	ETF	279.28	279.54	279.08	279.1	3555068.0
2019-02-27 15:30:00	SPY	ETF	279.1	279.31	278.89	279.23	7823301.0
2019-02-27 16:00:00	SPY	ETF	279.21	279.53	279.17	279.44	2946823.0
2019-02-27 16:30:00	SPY	ETF	279.46	279.69	279.2	279.58	560497.0
2019-02-27 17:00:00	SPY	ETF	279.58	279.58	279.45	279.57	161947.0
2019-02-27 17:30:00	SPY	ETF	279.57	279.58	279.4	279.45	692678.0
2019-02-27 18:00:00	SPY	ETF	279.49	279.52	279.38	279.43	99444.0
2019-02-27 18:30:00	SPY	ETF	279.44	279.45	279.33	279.41	24649.0
2019-02-27 19:00:00	SPY	ETF	279.34	279.34	279.13	279.18	45622.0
2019-02-27 19:30:00	SPY	ETF	279.25	279.26	279.06	279.07	47567.0
2019-02-27 04:00:00	QQQ	ETF	172.81	172.95	172.8	172.93	11639.0
2019-02-27 04:30:00	QQQ	ETF	172.94	172.98	172.89	172.98	11117.0
2019-02-27 05:00:00	QQQ	ETF	172.95	173.01	172.93	173.01	7526.0
2019-02-27 05:30:00	QQQ	ETF	173.04	173.17	173.03	173.13	32016.0
2019-02-27 06:00:00	QQQ	ETF	173.13	173.16	173.05	173.05	7300.0
2019-02-27 06:30:00	QQQ	ETF	173.03	173.12	173.03	173.11	2400.0
2019-02-27 07:00:00	QQQ	ETF	173.09	173.22	173.08	173.16	52265.0
2019-02-27 07:30:00	QQQ	ETF	173.16	173.24	173.05	173.07	40781.0
2019-02-27 08:00:00	QQQ	ETF	173.19	173.34	172.88	173.03	174565.0
2019-02-27 08:30:00	QQQ	ETF	173.02	173.14	172.91	172.91	178643.0
2019-02-27 09:00:00	QQQ	ETF	172.91	173.1	172.9	172.92	153616.0
2019-02-27 09:30:00	QQQ	ETF	172.92	173.49	172.71	172.795	2427439.0
2019-02-27 10:00:00	QQQ	ETF	172.8	172.92	171.76	172.04	4361365.0
2019-02-27 10:30:00	QQQ	ETF	172.04	172.44	171.85	172.27	2059268.0
2019-02-27 11:00:00	QQQ	ETF	172.27	172.84	172.19	172.73	1520211.0
2019-02-27 11:30:00	QQQ	ETF	172.7351	173.1699	172.7042	172.99	1389412.0
2019-02-27 12:00:00	QQQ	ETF	173.0	173.2451	173.0	173.1331	834614.0
2019-02-27 12:30:00	QQQ	ETF	173.14	173.29	173.09	173.1	480678.0

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

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