PREVIEW / etf_30min / 2018-05-25

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-25.parquet
  size:    441 KB
  rows:    15,272

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-05-25 04:00:00	SPY	ETF	273.2	273.46	273.2	273.46	15527.0
2018-05-25 04:30:00	SPY	ETF	273.5	273.61	273.44	273.61	7902.0
2018-05-25 05:00:00	SPY	ETF	273.68	273.69	273.5	273.51	4668.0
2018-05-25 05:30:00	SPY	ETF	273.54	273.57	273.41	273.51	6170.0
2018-05-25 06:00:00	SPY	ETF	273.46	273.54	273.31	273.54	20109.0
2018-05-25 06:30:00	SPY	ETF	273.57	273.61	273.45	273.45	30229.0
2018-05-25 07:00:00	SPY	ETF	273.42	273.52	272.84	272.91	98352.0
2018-05-25 07:30:00	SPY	ETF	272.91	272.93	272.49	272.54	107303.0
2018-05-25 08:00:00	SPY	ETF	272.54	273.65	272.18	272.3	408003.0
2018-05-25 08:30:00	SPY	ETF	272.27	272.4	272.05	272.11	296132.0
2018-05-25 09:00:00	SPY	ETF	272.1	272.35	271.83	272.18	717402.0
2018-05-25 09:30:00	SPY	ETF	272.15	272.53	271.81	272.29	6458079.0
2018-05-25 10:00:00	SPY	ETF	272.28	272.85	272.12	272.64	3848614.0
2018-05-25 10:30:00	SPY	ETF	272.65	272.86	272.23	272.52	2940531.0
2018-05-25 11:00:00	SPY	ETF	272.52	272.73	272.32	272.51	2573832.0
2018-05-25 11:30:00	SPY	ETF	272.52	272.65	272.39	272.39	2505179.0
2018-05-25 12:00:00	SPY	ETF	272.39	272.48	271.89	272.17	3672663.0
2018-05-25 12:30:00	SPY	ETF	272.16	272.31	271.94	272.1068	2297233.0
2018-05-25 13:00:00	SPY	ETF	272.095	272.2353	271.96	271.99	2122429.0
2018-05-25 13:30:00	SPY	ETF	271.98	271.98	271.7	271.78	1470569.0
2018-05-25 14:00:00	SPY	ETF	271.78	272.12	271.71	272.09	2219403.0
2018-05-25 14:30:00	SPY	ETF	272.1	272.13	271.58	271.685	1922902.0
2018-05-25 15:00:00	SPY	ETF	271.69	272.23	271.58	272.205	2346584.0
2018-05-25 15:30:00	SPY	ETF	272.21	272.39	271.9	272.18	8092216.0
2018-05-25 16:00:00	SPY	ETF	272.19	272.2792	271.95	271.99	9317428.0
2018-05-25 16:30:00	SPY	ETF	271.98	272.29	271.97	272.25	1157618.0
2018-05-25 17:00:00	SPY	ETF	272.27	272.27	272.19	272.21	49600.0
2018-05-25 17:30:00	SPY	ETF	272.21	272.34	272.21	272.34	17579.0
2018-05-25 18:00:00	SPY	ETF	272.27	272.27	272.21	272.22	3845.0
2018-05-25 18:30:00	SPY	ETF	272.24	272.33	272.24	272.27	6253.0
2018-05-25 19:00:00	SPY	ETF	272.27	272.3	272.23	272.26	4430.0
2018-05-25 19:30:00	SPY	ETF	272.27	272.31	272.26	272.3	15464.0
2018-05-25 04:00:00	QQQ	ETF	169.88	170.07	169.88	170.07	7356.0
2018-05-25 04:30:00	QQQ	ETF	170.11	170.23	170.11	170.23	4800.0
2018-05-25 05:00:00	QQQ	ETF	170.24	170.25	170.18	170.19	4100.0
2018-05-25 05:30:00	QQQ	ETF	170.18	170.28	170.15	170.28	1600.0
2018-05-25 06:00:00	QQQ	ETF	170.2	170.29	170.11	170.29	7000.0
2018-05-25 06:30:00	QQQ	ETF	170.3	170.3	170.15	170.15	8690.0
2018-05-25 07:00:00	QQQ	ETF	170.14	170.21	169.8	169.82	21112.0
2018-05-25 07:30:00	QQQ	ETF	169.83	169.87	169.6	169.64	53739.0
2018-05-25 08:00:00	QQQ	ETF	169.6999	170.14	169.42	169.54	107740.0
2018-05-25 08:30:00	QQQ	ETF	169.53	169.67	169.41	169.47	182578.0
2018-05-25 09:00:00	QQQ	ETF	169.45	169.63	169.21	169.52	219605.0
2018-05-25 09:30:00	QQQ	ETF	169.52	169.99	169.21	169.885	3173935.0
2018-05-25 10:00:00	QQQ	ETF	169.87	170.27	169.73	170.19	2579310.0
2018-05-25 10:30:00	QQQ	ETF	170.2	170.31	169.89	170.11	1920570.0
2018-05-25 11:00:00	QQQ	ETF	170.1111	170.22	169.89	170.09	1290486.0
2018-05-25 11:30:00	QQQ	ETF	170.09	170.33	170.05	170.0801	1220559.0
2018-05-25 12:00:00	QQQ	ETF	170.08	170.14	169.7	170.04	1445441.0
2018-05-25 12:30:00	QQQ	ETF	170.04	170.17	169.8802	169.98	829173.0

> showing 50 of 15,272 rows — these rows as CSV

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