PREVIEW / etf_30min / 2018-05-04

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-04.parquet
  size:    450 KB
  rows:    15,517

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-04 04:00:00	SPY	ETF	262.96	263.18	262.85	262.85	5837.0
2018-05-04 04:30:00	SPY	ETF	262.84	262.85	262.6	262.8	3552.0
2018-05-04 05:00:00	SPY	ETF	262.85	262.85	262.65	262.65	2840.0
2018-05-04 05:30:00	SPY	ETF	262.51	262.87	262.51	262.87	3000.0
2018-05-04 06:00:00	SPY	ETF	262.85	263.01	262.77	262.77	44050.0
2018-05-04 06:30:00	SPY	ETF	262.73	262.73	262.48	262.54	9980.0
2018-05-04 07:00:00	SPY	ETF	262.53	262.62	262.43	262.51	38566.0
2018-05-04 07:30:00	SPY	ETF	262.59	262.59	262.18	262.26	60173.0
2018-05-04 08:00:00	SPY	ETF	262.27	263.14	261.89	262.08	264716.0
2018-05-04 08:30:00	SPY	ETF	262.16	262.85	261.62	262.36	1046531.0
2018-05-04 09:00:00	SPY	ETF	262.36	262.55	261.41	261.49	784836.0
2018-05-04 09:30:00	SPY	ETF	261.52	262.71	261.15	262.5511	7068785.0
2018-05-04 10:00:00	SPY	ETF	262.56	263.8	262.28	263.75	5976667.0
2018-05-04 10:30:00	SPY	ETF	263.75	264.69	263.635	264.4258	7349286.0
2018-05-04 11:00:00	SPY	ETF	264.43	265.07	264.37	264.99	4394971.0
2018-05-04 11:30:00	SPY	ETF	264.99	265.33	264.79	265.18	4507645.0
2018-05-04 12:00:00	SPY	ETF	265.185	265.47	265.02	265.365	2778781.0
2018-05-04 12:30:00	SPY	ETF	265.37	265.62	265.29	265.44	2259389.0
2018-05-04 13:00:00	SPY	ETF	265.45	265.76	265.34	265.55	3109211.0
2018-05-04 13:30:00	SPY	ETF	265.55	266.05	265.47	266.03	3368462.0
2018-05-04 14:00:00	SPY	ETF	266.04	266.6441	265.92	266.61	3873129.0
2018-05-04 14:30:00	SPY	ETF	266.6	266.7892	266.28	266.28	4736243.0
2018-05-04 15:00:00	SPY	ETF	266.28	266.63	266.17	266.45	4215703.0
2018-05-04 15:30:00	SPY	ETF	266.44	266.51	265.56	266.0	13831199.0
2018-05-04 16:00:00	SPY	ETF	265.99	266.23	265.83	266.22	10900199.0
2018-05-04 16:30:00	SPY	ETF	266.2	266.24	266.02	266.2	1409938.0
2018-05-04 17:00:00	SPY	ETF	266.17	266.22	266.02	266.12	4077365.0
2018-05-04 17:30:00	SPY	ETF	266.17	266.18	266.14	266.15	7468.0
2018-05-04 18:00:00	SPY	ETF	266.15	266.34	266.15	266.34	17501.0
2018-05-04 18:30:00	SPY	ETF	266.33	266.38	266.28	266.36	17335.0
2018-05-04 19:00:00	SPY	ETF	266.36	266.4	266.36	266.36	6866.0
2018-05-04 19:30:00	SPY	ETF	266.36	266.44	266.36	266.36	17816.0
2018-05-04 04:00:00	QQQ	ETF	162.05	162.3	162.03	162.03	12138.0
2018-05-04 04:30:00	QQQ	ETF	161.98	161.98	161.83	161.93	13040.0
2018-05-04 05:00:00	QQQ	ETF	161.92	161.92	161.79	161.79	3150.0
2018-05-04 05:30:00	QQQ	ETF	161.78	162.0	161.78	161.98	7070.0
2018-05-04 06:00:00	QQQ	ETF	162.09	162.09	162.0	162.0	5900.0
2018-05-04 06:30:00	QQQ	ETF	162.0	162.04	161.88	161.88	7275.0
2018-05-04 07:00:00	QQQ	ETF	161.89	162.01	161.86	161.97	25389.0
2018-05-04 07:30:00	QQQ	ETF	161.96	162.03	161.7	161.71	55998.0
2018-05-04 08:00:00	QQQ	ETF	161.91	161.94	161.42	161.61	99680.0
2018-05-04 08:30:00	QQQ	ETF	161.65	162.06	161.19	161.7	474959.0
2018-05-04 09:00:00	QQQ	ETF	161.71	161.88	161.051	161.09	393193.0
2018-05-04 09:30:00	QQQ	ETF	161.12	162.25	160.98	162.19	2762759.0
2018-05-04 10:00:00	QQQ	ETF	162.19	163.245	161.865	163.17	2888549.0
2018-05-04 10:30:00	QQQ	ETF	163.19	163.99	163.15	163.82	3925953.0
2018-05-04 11:00:00	QQQ	ETF	163.83	164.24	163.83	164.2	2799747.0
2018-05-04 11:30:00	QQQ	ETF	164.21	164.42	164.02	164.23	1885391.0
2018-05-04 12:00:00	QQQ	ETF	164.24	164.47	164.11	164.34	1547799.0
2018-05-04 12:30:00	QQQ	ETF	164.35	164.54	164.21	164.3199	1881765.0

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

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