PREVIEW / etf_30min / 2018-02-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-27.parquet
  size:    485 KB
  rows:    16,617

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-02-27 04:00:00	SPY	ETF	277.8	277.8	277.55	277.67	5647.0
2018-02-27 04:30:00	SPY	ETF	277.68	277.77	277.52	277.74	3840.0
2018-02-27 05:00:00	SPY	ETF	277.83	277.88	277.71	277.88	5602.0
2018-02-27 05:30:00	SPY	ETF	277.91	278.13	277.91	277.93	15806.0
2018-02-27 06:00:00	SPY	ETF	277.87	278.0	277.54	277.62	33187.0
2018-02-27 06:30:00	SPY	ETF	277.69	277.74	277.42	277.64	32134.0
2018-02-27 07:00:00	SPY	ETF	277.56	278.02	277.53	277.99	419069.0
2018-02-27 07:30:00	SPY	ETF	278.02	278.22	277.94	278.08	78046.0
2018-02-27 08:00:00	SPY	ETF	277.99	278.35	277.66	277.97	238318.0
2018-02-27 08:30:00	SPY	ETF	277.96	278.2	277.55	278.03	978235.0
2018-02-27 09:00:00	SPY	ETF	278.04	278.25	277.86	278.14	695846.0
2018-02-27 09:30:00	SPY	ETF	278.11	278.44	277.61	277.73	7820331.0
2018-02-27 10:00:00	SPY	ETF	277.73	278.92	277.65	278.61	5375097.0
2018-02-27 10:30:00	SPY	ETF	278.61	278.71	276.62	277.0	10147797.0
2018-02-27 11:00:00	SPY	ETF	276.99	277.68	276.67	276.93	6295304.0
2018-02-27 11:30:00	SPY	ETF	276.95	277.43	276.29	276.32	4750668.0
2018-02-27 12:00:00	SPY	ETF	276.305	276.75	275.66	276.175	4914782.0
2018-02-27 12:30:00	SPY	ETF	276.1675	277.18	276.12	277.13	5687445.0
2018-02-27 13:00:00	SPY	ETF	277.14	277.26	276.74	276.95	3240004.0
2018-02-27 13:30:00	SPY	ETF	276.94	276.96	276.17	276.35	3311362.0
2018-02-27 14:00:00	SPY	ETF	276.36	276.52	275.599	276.09	3661782.0
2018-02-27 14:30:00	SPY	ETF	276.07	276.59	275.58	276.03	4490598.0
2018-02-27 15:00:00	SPY	ETF	276.025	276.18	275.06	275.485	7275889.0
2018-02-27 15:30:00	SPY	ETF	275.48	275.7602	274.36	274.38	13520503.0
2018-02-27 16:00:00	SPY	ETF	274.38	274.87	274.1632	274.86	10332440.0
2018-02-27 16:30:00	SPY	ETF	274.86	274.92	274.397	274.69	1348722.0
2018-02-27 17:00:00	SPY	ETF	274.65	274.72	274.57	274.58	66818.0
2018-02-27 17:30:00	SPY	ETF	274.6	277.1402	274.58	274.6	51793.0
2018-02-27 18:00:00	SPY	ETF	274.61	275.04	274.61	274.9	303670.0
2018-02-27 18:30:00	SPY	ETF	274.9	275.3	274.43	275.27	351388.0
2018-02-27 19:00:00	SPY	ETF	275.27	275.4	275.27	275.31	44209.0
2018-02-27 19:30:00	SPY	ETF	275.33	275.4	275.22	275.3	53049.0
2018-02-27 04:00:00	QQQ	ETF	170.2	170.24	170.04	170.14	72001.0
2018-02-27 04:30:00	QQQ	ETF	170.02	170.15	169.96	170.11	7500.0
2018-02-27 05:00:00	QQQ	ETF	170.18	170.21	170.18	170.19	2300.0
2018-02-27 05:30:00	QQQ	ETF	170.21	170.41	170.21	170.34	6290.0
2018-02-27 06:00:00	QQQ	ETF	170.24	170.24	170.05	170.13	4910.0
2018-02-27 06:30:00	QQQ	ETF	170.07	170.16	169.96	170.1	48539.0
2018-02-27 07:00:00	QQQ	ETF	170.04	170.24	170.01	170.23	16436.0
2018-02-27 07:30:00	QQQ	ETF	170.25	170.33	170.19	170.26	11863.0
2018-02-27 08:00:00	QQQ	ETF	170.07	170.5	170.07	170.29	85206.0
2018-02-27 08:30:00	QQQ	ETF	170.29	170.51	170.06	170.4	168271.0
2018-02-27 09:00:00	QQQ	ETF	170.43	170.52	170.29	170.41	118862.0
2018-02-27 09:30:00	QQQ	ETF	170.42	170.52	169.71	169.82	3439693.0
2018-02-27 10:00:00	QQQ	ETF	169.82	170.73	169.79	170.58	2081674.0
2018-02-27 10:30:00	QQQ	ETF	170.6	170.66	169.27	169.45	4181384.0
2018-02-27 11:00:00	QQQ	ETF	169.45	169.855	169.21	169.26	3225620.0
2018-02-27 11:30:00	QQQ	ETF	169.28	169.59	168.94	168.96	2920376.0
2018-02-27 12:00:00	QQQ	ETF	168.97	169.26	168.4	168.755	2158076.0
2018-02-27 12:30:00	QQQ	ETF	168.755	169.52	168.71	169.5	2499786.0

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

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