PREVIEW / etf_30min / 2018-05-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-03.parquet
  size:    459 KB
  rows:    15,817

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-03 04:00:00	SPY	ETF	263.06	263.39	263.06	263.23	34858.0
2018-05-03 04:30:00	SPY	ETF	263.22	263.33	263.21	263.3	4645.0
2018-05-03 05:00:00	SPY	ETF	263.33	263.53	263.23	263.23	6033.0
2018-05-03 05:30:00	SPY	ETF	263.27	263.32	263.03	263.06	4970.0
2018-05-03 06:00:00	SPY	ETF	263.12	263.3	263.06	263.28	11045.0
2018-05-03 06:30:00	SPY	ETF	263.28	263.32	263.15	263.15	17329.0
2018-05-03 07:00:00	SPY	ETF	263.16	263.2	262.68	262.72	120024.0
2018-05-03 07:30:00	SPY	ETF	262.72	262.88	261.73	261.88	233070.0
2018-05-03 08:00:00	SPY	ETF	262.5301	263.17	261.64	261.95	451169.0
2018-05-03 08:30:00	SPY	ETF	261.94	262.22	261.8	261.87	396487.0
2018-05-03 09:00:00	SPY	ETF	261.9	263.2	261.86	262.25	610294.0
2018-05-03 09:30:00	SPY	ETF	262.26	262.3388	261.14	262.166	10264835.0
2018-05-03 10:00:00	SPY	ETF	262.16	262.175	260.21	260.49	12818878.0
2018-05-03 10:30:00	SPY	ETF	260.47	260.54	259.05	259.5498	18220578.0
2018-05-03 11:00:00	SPY	ETF	259.54	260.45	259.35	259.65	11579881.0
2018-05-03 11:30:00	SPY	ETF	259.65	260.71	259.36	260.5148	7326260.0
2018-05-03 12:00:00	SPY	ETF	260.51	260.92	260.0	260.02	5769132.0
2018-05-03 12:30:00	SPY	ETF	260.03	262.7	260.0	262.58	9593075.0
2018-05-03 13:00:00	SPY	ETF	262.58	262.69	261.78	262.05	7551036.0
2018-05-03 13:30:00	SPY	ETF	262.06	263.13	262.05	262.65	5256985.0
2018-05-03 14:00:00	SPY	ETF	262.64	262.82	262.2	262.59	4629847.0
2018-05-03 14:30:00	SPY	ETF	262.59	263.36	262.19	262.42	8831409.0
2018-05-03 15:00:00	SPY	ETF	262.41	262.88	262.23	262.81	4515128.0
2018-05-03 15:30:00	SPY	ETF	262.82	263.1	262.08	262.61	11833945.0
2018-05-03 16:00:00	SPY	ETF	262.59	263.15	262.59	262.97	12821682.0
2018-05-03 16:30:00	SPY	ETF	262.97	263.08	262.6095	262.95	1340996.0
2018-05-03 17:00:00	SPY	ETF	263.02	263.07	262.94	263.0	25631.0
2018-05-03 17:30:00	SPY	ETF	263.0	263.02	262.62	263.0	30537.0
2018-05-03 18:00:00	SPY	ETF	263.03	263.22	263.03	263.1	21976.0
2018-05-03 18:30:00	SPY	ETF	263.07	263.07	263.03	263.05	4760.0
2018-05-03 19:00:00	SPY	ETF	263.09	263.09	262.72	262.8	67260.0
2018-05-03 19:30:00	SPY	ETF	262.86	262.88	262.43	262.56	172610.0
2018-05-03 20:00:00	SPY	ETF	262.62	262.62	262.6	262.6	1000.0
2018-05-03 04:00:00	QQQ	ETF	161.85	161.93	161.79	161.79	3444.0
2018-05-03 04:30:00	QQQ	ETF	161.8	161.84	161.79	161.8	2800.0
2018-05-03 05:00:00	QQQ	ETF	161.88	161.91	161.88	161.9	1300.0
2018-05-03 05:30:00	QQQ	ETF	161.73	161.73	161.73	161.73	500.0
2018-05-03 06:00:00	QQQ	ETF	161.87	161.87	161.85	161.85	300.0
2018-05-03 06:30:00	QQQ	ETF	161.82	161.87	161.8	161.81	7300.0
2018-05-03 07:00:00	QQQ	ETF	161.82	161.85	161.48	161.53	35500.0
2018-05-03 07:30:00	QQQ	ETF	161.55	161.65	160.83	160.93	72864.0
2018-05-03 08:00:00	QQQ	ETF	160.96	161.8	160.7	161.03	115515.0
2018-05-03 08:30:00	QQQ	ETF	161.03	161.19	160.85	160.93	144286.0
2018-05-03 09:00:00	QQQ	ETF	160.97	161.16	160.87	161.09	250142.0
2018-05-03 09:30:00	QQQ	ETF	161.08	161.66	160.48	161.51	4501655.0
2018-05-03 10:00:00	QQQ	ETF	161.5	161.54	160.18	160.45	4650853.0
2018-05-03 10:30:00	QQQ	ETF	160.45	160.529	159.22	159.5048	6681927.0
2018-05-03 11:00:00	QQQ	ETF	159.51	160.139	159.2808	159.58	4370017.0
2018-05-03 11:30:00	QQQ	ETF	159.58	160.44	159.44	160.28	3296233.0
2018-05-03 12:00:00	QQQ	ETF	160.2899	160.5	159.85	159.86	1747274.0

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

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