PREVIEW / etf_30min / 2018-05-10

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-10.parquet
  size:    467 KB
  rows:    16,040

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-10 04:00:00	SPY	ETF	270.03	270.11	269.94	269.99	11020.0
2018-05-10 04:30:00	SPY	ETF	269.99	270.04	269.94	270.01	5550.0
2018-05-10 05:00:00	SPY	ETF	270.06	270.13	270.0	270.06	3950.0
2018-05-10 05:30:00	SPY	ETF	270.02	270.02	269.7	269.8	3321.0
2018-05-10 06:00:00	SPY	ETF	269.71	269.83	269.71	269.76	3101.0
2018-05-10 06:30:00	SPY	ETF	269.78	269.78	269.58	269.66	14500.0
2018-05-10 07:00:00	SPY	ETF	269.73	269.81	269.58	269.81	87121.0
2018-05-10 07:30:00	SPY	ETF	269.85	270.12	269.8	270.07	89330.0
2018-05-10 08:00:00	SPY	ETF	269.66	270.19	269.66	269.9	93917.0
2018-05-10 08:30:00	SPY	ETF	269.95	270.57	269.7	270.37	679130.0
2018-05-10 09:00:00	SPY	ETF	270.33	270.4	270.19	270.32	222189.0
2018-05-10 09:30:00	SPY	ETF	270.34	270.81	270.22	270.62	5317085.0
2018-05-10 10:00:00	SPY	ETF	270.62	270.88	270.28	270.85	4992744.0
2018-05-10 10:30:00	SPY	ETF	270.85	271.12	270.745	270.945	3561845.0
2018-05-10 11:00:00	SPY	ETF	270.95	271.48	270.89	271.39	4031010.0
2018-05-10 11:30:00	SPY	ETF	271.4	271.71	271.29	271.665	3266799.0
2018-05-10 12:00:00	SPY	ETF	271.665	272.19	271.61	272.12	4022445.0
2018-05-10 12:30:00	SPY	ETF	272.115	272.26	271.955	272.06	3242087.0
2018-05-10 13:00:00	SPY	ETF	272.07	272.39	271.93	271.95	4262120.0
2018-05-10 13:30:00	SPY	ETF	271.94	272.07	271.55	271.72	3476116.0
2018-05-10 14:00:00	SPY	ETF	271.73	271.99	271.4	271.915	3015731.0
2018-05-10 14:30:00	SPY	ETF	271.91	272.06	271.2	271.95	4203102.0
2018-05-10 15:00:00	SPY	ETF	271.95	272.15	271.58	271.825	4826309.0
2018-05-10 15:30:00	SPY	ETF	271.83	272.23	271.575	272.01	10116142.0
2018-05-10 16:00:00	SPY	ETF	272.01	272.0616	270.3	271.71	9223650.0
2018-05-10 16:30:00	SPY	ETF	271.75	272.02	271.55	271.55	601000.0
2018-05-10 17:00:00	SPY	ETF	271.56	272.02	271.48	271.55	123046.0
2018-05-10 17:30:00	SPY	ETF	271.55	272.02	271.5	271.53	324136.0
2018-05-10 18:00:00	SPY	ETF	271.58	271.87	271.58	271.69	941257.0
2018-05-10 18:30:00	SPY	ETF	271.7	271.7	271.67	271.69	17940.0
2018-05-10 19:00:00	SPY	ETF	271.7	271.82	271.7	271.78	1450.0
2018-05-10 19:30:00	SPY	ETF	271.75	271.93	271.7	271.93	15541.0
2018-05-10 04:00:00	QQQ	ETF	168.2	168.32	168.2	168.24	8752.0
2018-05-10 04:30:00	QQQ	ETF	168.24	168.25	168.19	168.23	11979.0
2018-05-10 05:00:00	QQQ	ETF	168.29	168.29	168.21	168.21	1050.0
2018-05-10 05:30:00	QQQ	ETF	168.17	168.17	168.0	168.15	8980.0
2018-05-10 06:00:00	QQQ	ETF	168.18	168.18	168.15	168.15	300.0
2018-05-10 06:30:00	QQQ	ETF	168.17	168.17	168.06	168.08	11800.0
2018-05-10 07:00:00	QQQ	ETF	168.13	168.2	168.03	168.2	44845.0
2018-05-10 07:30:00	QQQ	ETF	168.2	168.29	168.17	168.19	72721.0
2018-05-10 08:00:00	QQQ	ETF	167.88	168.27	167.88	168.05	76777.0
2018-05-10 08:30:00	QQQ	ETF	168.1	168.57	168.1	168.47	294362.0
2018-05-10 09:00:00	QQQ	ETF	168.45	168.5	168.4	168.43	99670.0
2018-05-10 09:30:00	QQQ	ETF	168.43	168.8	168.29	168.62	2298309.0
2018-05-10 10:00:00	QQQ	ETF	168.64	168.8561	168.42	168.84	1547697.0
2018-05-10 10:30:00	QQQ	ETF	168.84	169.08	168.74	168.97	1541427.0
2018-05-10 11:00:00	QQQ	ETF	168.96	169.25	168.93	169.149	1332396.0
2018-05-10 11:30:00	QQQ	ETF	169.15	169.215	169.05	169.15	1004399.0
2018-05-10 12:00:00	QQQ	ETF	169.15	169.48	169.1	169.3958	1425920.0
2018-05-10 12:30:00	QQQ	ETF	169.39	169.48	169.28	169.44	1089984.0

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

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