PREVIEW / etf_30min / 2018-10-24

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-24.parquet
  size:    509 KB
  rows:    17,624

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-10-24 04:00:00	SPY	ETF	272.42	272.45	271.72	271.96	45170.0
2018-10-24 04:30:00	SPY	ETF	271.9	272.04	271.42	271.48	73939.0
2018-10-24 05:00:00	SPY	ETF	271.46	272.19	271.41	271.95	52863.0
2018-10-24 05:30:00	SPY	ETF	271.95	272.31	271.82	272.29	57985.0
2018-10-24 06:00:00	SPY	ETF	272.21	272.43	272.15	272.31	50753.0
2018-10-24 06:30:00	SPY	ETF	272.39	272.65	272.2	272.65	139670.0
2018-10-24 07:00:00	SPY	ETF	272.66	272.84	272.49	272.84	285899.0
2018-10-24 07:30:00	SPY	ETF	272.89	274.03	272.81	273.96	583256.0
2018-10-24 08:00:00	SPY	ETF	272.61	274.11	272.0	273.6	589933.0
2018-10-24 08:30:00	SPY	ETF	273.58	273.84	273.4	273.67	349117.0
2018-10-24 09:00:00	SPY	ETF	273.65	273.735	273.27	273.34	557154.0
2018-10-24 09:30:00	SPY	ETF	273.33	273.76	272.54	272.7701	8190362.0
2018-10-24 10:00:00	SPY	ETF	272.78	273.12	272.02	272.2	7788801.0
2018-10-24 10:30:00	SPY	ETF	272.19	272.76	271.49	271.53	6691341.0
2018-10-24 11:00:00	SPY	ETF	271.54	271.72	269.9	270.14	13352403.0
2018-10-24 11:30:00	SPY	ETF	270.14	272.2776	269.81	271.995	9931170.0
2018-10-24 12:00:00	SPY	ETF	271.99	272.16	271.08	271.41	6134014.0
2018-10-24 12:30:00	SPY	ETF	271.4	271.53	270.31	271.01	4562976.0
2018-10-24 13:00:00	SPY	ETF	271.02	271.02	269.4	269.77	6502063.0
2018-10-24 13:30:00	SPY	ETF	269.78	270.36	269.17	269.49	7642253.0
2018-10-24 14:00:00	SPY	ETF	269.49	270.31	268.71	270.2	10825740.0
2018-10-24 14:30:00	SPY	ETF	270.2	270.61	268.9	269.2	8941786.0
2018-10-24 15:00:00	SPY	ETF	269.215	269.215	267.1	267.17	16285006.0
2018-10-24 15:30:00	SPY	ETF	267.18	267.86	264.7	265.22	39460579.0
2018-10-24 16:00:00	SPY	ETF	265.25	267.2556	265.08	266.28	18691022.0
2018-10-24 16:30:00	SPY	ETF	266.29	269.3	265.1451	266.88	2591264.0
2018-10-24 17:00:00	SPY	ETF	266.89	266.89	265.32	266.75	2654639.0
2018-10-24 17:30:00	SPY	ETF	266.76	266.9	265.32	266.79	1339788.0
2018-10-24 18:00:00	SPY	ETF	266.8	266.82	265.32	266.34	555307.0
2018-10-24 18:30:00	SPY	ETF	266.35	266.68	266.18	266.62	173290.0
2018-10-24 19:00:00	SPY	ETF	266.66	266.83	266.22	266.3	85008.0
2018-10-24 19:30:00	SPY	ETF	266.25	266.25	265.3	265.69	197303.0
2018-10-24 20:00:00	SPY	ETF	265.32	265.75	265.32	265.75	300.0
2018-10-24 04:00:00	QQQ	ETF	172.5	172.5	171.85	171.86	50876.0
2018-10-24 04:30:00	QQQ	ETF	171.89	172.04	171.52	171.59	18117.0
2018-10-24 05:00:00	QQQ	ETF	171.49	172.06	171.47	171.93	24278.0
2018-10-24 05:30:00	QQQ	ETF	171.82	172.19	171.8	172.05	14573.0
2018-10-24 06:00:00	QQQ	ETF	172.0	172.24	172.0	172.2	11924.0
2018-10-24 06:30:00	QQQ	ETF	172.2	172.48	172.07	172.4	39472.0
2018-10-24 07:00:00	QQQ	ETF	172.49	172.8	172.39	172.8	97402.0
2018-10-24 07:30:00	QQQ	ETF	172.82	173.69	172.81	173.69	268145.0
2018-10-24 08:00:00	QQQ	ETF	173.27	173.85	172.0	173.35	356928.0
2018-10-24 08:30:00	QQQ	ETF	173.34	173.61	173.17	173.55	193094.0
2018-10-24 09:00:00	QQQ	ETF	173.52	173.62	173.11	173.12	343345.0
2018-10-24 09:30:00	QQQ	ETF	173.12	173.36	171.99	172.36	6933966.0
2018-10-24 10:00:00	QQQ	ETF	172.37	172.87	171.71	171.85	4336327.0
2018-10-24 10:30:00	QQQ	ETF	171.81	172.25	171.52	171.56	3096549.0
2018-10-24 11:00:00	QQQ	ETF	171.56	171.73	170.07	170.1	5735858.0
2018-10-24 11:30:00	QQQ	ETF	170.13	171.73	169.8	171.5	6546605.0
2018-10-24 12:00:00	QQQ	ETF	171.49	171.59	170.6801	170.8915	3233154.0

> showing 50 of 17,624 rows — these rows as CSV

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