PREVIEW / etf_30min / 2018-03-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-01.parquet
  size:    497 KB
  rows:    17,109

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-03-01 04:00:00	SPY	ETF	272.0	272.0	271.46	271.72	45849.0
2018-03-01 04:30:00	SPY	ETF	271.76	271.81	270.72	270.83	55889.0
2018-03-01 05:00:00	SPY	ETF	270.95	271.17	270.54	270.77	31068.0
2018-03-01 05:30:00	SPY	ETF	270.67	271.16	270.67	271.13	17683.0
2018-03-01 06:00:00	SPY	ETF	271.07	271.33	271.06	271.1	17046.0
2018-03-01 06:30:00	SPY	ETF	271.06	271.09	269.94	270.38	114865.0
2018-03-01 07:00:00	SPY	ETF	270.36	270.75	270.24	270.44	307352.0
2018-03-01 07:30:00	SPY	ETF	270.58	270.94	270.46	270.59	211093.0
2018-03-01 08:00:00	SPY	ETF	270.66	272.16	270.31	270.9	673123.0
2018-03-01 08:30:00	SPY	ETF	270.9	271.85	270.83	271.7	791870.0
2018-03-01 09:00:00	SPY	ETF	271.72	272.02	271.43	271.44	615829.0
2018-03-01 09:30:00	SPY	ETF	271.41	272.09	270.02	270.24	13500705.0
2018-03-01 10:00:00	SPY	ETF	270.22	272.03	269.95	272.0	10680112.0
2018-03-01 10:30:00	SPY	ETF	272.0	273.17	270.91	271.13	9417671.0
2018-03-01 11:00:00	SPY	ETF	271.12	271.92	270.72	271.0034	5972410.0
2018-03-01 11:30:00	SPY	ETF	270.99	272.245	270.83	271.8	4407722.0
2018-03-01 12:00:00	SPY	ETF	271.8	271.87	270.07	270.4325	5956807.0
2018-03-01 12:30:00	SPY	ETF	270.42	270.73	269.68	269.95	9868324.0
2018-03-01 13:00:00	SPY	ETF	269.94	269.94	268.14	269.08	14287979.0
2018-03-01 13:30:00	SPY	ETF	269.07	269.28	267.28	267.2938	8719208.0
2018-03-01 14:00:00	SPY	ETF	267.3	267.51	266.0	267.41	19171428.0
2018-03-01 14:30:00	SPY	ETF	267.415	267.58	266.41	267.16	11446767.0
2018-03-01 15:00:00	SPY	ETF	267.16	268.99	266.49	268.36	16017028.0
2018-03-01 15:30:00	SPY	ETF	268.39	268.73	266.85	267.73	25948836.0
2018-03-01 16:00:00	SPY	ETF	267.73	268.45	267.63	268.03	14507098.0
2018-03-01 16:30:00	SPY	ETF	267.99	268.2	267.7	268.11	1521232.0
2018-03-01 17:00:00	SPY	ETF	268.15	271.2841	267.7	267.99	152240.0
2018-03-01 17:30:00	SPY	ETF	268.0	268.0	267.88	267.91	53056.0
2018-03-01 18:00:00	SPY	ETF	267.95	268.29	267.7	267.8	206621.0
2018-03-01 18:30:00	SPY	ETF	267.89	268.19	267.89	268.19	58188.0
2018-03-01 19:00:00	SPY	ETF	268.19	268.51	268.18	268.48	48209.0
2018-03-01 19:30:00	SPY	ETF	268.46	268.53	268.38	268.5	32249.0
2018-03-01 04:00:00	QQQ	ETF	167.13	169.19	167.13	167.65	6729.0
2018-03-01 04:30:00	QQQ	ETF	167.63	167.64	166.99	167.04	36396.0
2018-03-01 05:00:00	QQQ	ETF	167.05	167.22	166.84	166.91	13783.0
2018-03-01 05:30:00	QQQ	ETF	167.01	167.25	166.92	167.16	14296.0
2018-03-01 06:00:00	QQQ	ETF	167.22	167.22	167.16	167.17	2502.0
2018-03-01 06:30:00	QQQ	ETF	167.11	167.11	166.27	166.57	47887.0
2018-03-01 07:00:00	QQQ	ETF	166.6	166.86	166.5	166.7	187843.0
2018-03-01 07:30:00	QQQ	ETF	166.83	167.0	166.72	166.82	65546.0
2018-03-01 08:00:00	QQQ	ETF	166.57	167.05	166.57	166.9	60230.0
2018-03-01 08:30:00	QQQ	ETF	167.0	167.67	166.96	167.62	222449.0
2018-03-01 09:00:00	QQQ	ETF	167.61	167.7	167.29	167.29	354479.0
2018-03-01 09:30:00	QQQ	ETF	167.29	167.86	165.72	165.88	7280867.0
2018-03-01 10:00:00	QQQ	ETF	165.89	167.32	165.61	167.31	6447732.0
2018-03-01 10:30:00	QQQ	ETF	167.31	168.07	166.41	166.58	5201590.0
2018-03-01 11:00:00	QQQ	ETF	166.57	167.24	166.46	166.65	2617616.0
2018-03-01 11:30:00	QQQ	ETF	166.65	167.5	166.56	167.22	2061244.0
2018-03-01 12:00:00	QQQ	ETF	167.24	167.28	166.06	166.27	2532471.0
2018-03-01 12:30:00	QQQ	ETF	166.26	166.3899	165.7533	165.88	2378152.0

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

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