PREVIEW / etf_30min / 2018-04-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-16.parquet
  size:    454 KB
  rows:    15,631

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-04-16 04:00:00	SPY	ETF	266.0	266.4	266.0	266.22	5340.0
2018-04-16 04:30:00	SPY	ETF	266.26	266.43	266.26	266.43	1000.0
2018-04-16 05:00:00	SPY	ETF	266.41	266.89	266.41	266.89	9521.0
2018-04-16 05:30:00	SPY	ETF	266.86	266.96	266.83	266.96	39990.0
2018-04-16 06:00:00	SPY	ETF	266.92	267.01	266.74	267.01	25153.0
2018-04-16 06:30:00	SPY	ETF	266.92	266.92	266.69	266.84	54805.0
2018-04-16 07:00:00	SPY	ETF	266.91	267.01	266.64	266.69	193723.0
2018-04-16 07:30:00	SPY	ETF	266.69	266.76	266.5	266.63	66822.0
2018-04-16 08:00:00	SPY	ETF	266.64	266.93	265.8	266.72	299172.0
2018-04-16 08:30:00	SPY	ETF	266.72	267.19	266.52	267.17	693432.0
2018-04-16 09:00:00	SPY	ETF	267.19	267.29	266.99	267.0	459857.0
2018-04-16 09:30:00	SPY	ETF	267.0	267.08	266.07	266.44	6078142.0
2018-04-16 10:00:00	SPY	ETF	266.43	267.15	266.39	267.09	4034563.0
2018-04-16 10:30:00	SPY	ETF	267.1	267.2	266.5	266.75	3498955.0
2018-04-16 11:00:00	SPY	ETF	266.77	267.13	266.4	266.93	2422333.0
2018-04-16 11:30:00	SPY	ETF	266.93	267.01	266.62	267.0	2000673.0
2018-04-16 12:00:00	SPY	ETF	267.0	267.41	266.99	267.1148	3250482.0
2018-04-16 12:30:00	SPY	ETF	267.12	267.94	266.93	267.73	3192646.0
2018-04-16 13:00:00	SPY	ETF	267.72	268.19	267.72	267.89	3425090.0
2018-04-16 13:30:00	SPY	ETF	267.8999	268.2	267.84	268.0501	2795418.0
2018-04-16 14:00:00	SPY	ETF	268.06	268.11	267.38	267.55	4543702.0
2018-04-16 14:30:00	SPY	ETF	267.55	267.93	267.46	267.63	2329212.0
2018-04-16 15:00:00	SPY	ETF	267.63	267.82	267.13	267.47	4398581.0
2018-04-16 15:30:00	SPY	ETF	267.47	267.88	267.27	267.32	10272299.0
2018-04-16 16:00:00	SPY	ETF	267.33	267.87	267.3045	267.67	7150713.0
2018-04-16 16:30:00	SPY	ETF	267.64	267.64	267.33	267.44	339234.0
2018-04-16 17:00:00	SPY	ETF	267.52	267.57	267.45	267.56	78493.0
2018-04-16 17:30:00	SPY	ETF	267.55	267.55	267.4	267.41	54094.0
2018-04-16 18:00:00	SPY	ETF	267.47	267.67	267.46	267.46	531742.0
2018-04-16 18:30:00	SPY	ETF	267.44	267.74	267.38	267.73	22248.0
2018-04-16 19:00:00	SPY	ETF	267.68	267.83	267.64	267.71	7718.0
2018-04-16 19:30:00	SPY	ETF	267.71	267.8	267.57	267.63	29934.0
2018-04-16 04:00:00	QQQ	ETF	161.88	162.29	161.88	162.22	7500.0
2018-04-16 04:30:00	QQQ	ETF	162.05	162.25	162.05	162.25	859.0
2018-04-16 05:00:00	QQQ	ETF	162.18	162.5	162.18	162.5	2950.0
2018-04-16 05:30:00	QQQ	ETF	162.55	162.72	162.51	162.69	6270.0
2018-04-16 06:00:00	QQQ	ETF	162.56	162.72	162.53	162.55	2780.0
2018-04-16 06:30:00	QQQ	ETF	162.63	162.72	162.41	162.64	26100.0
2018-04-16 07:00:00	QQQ	ETF	162.59	162.6	162.3	162.34	173043.0
2018-04-16 07:30:00	QQQ	ETF	162.33	162.38	162.25	162.33	57146.0
2018-04-16 08:00:00	QQQ	ETF	162.36	162.48	162.25	162.42	75109.0
2018-04-16 08:30:00	QQQ	ETF	162.34	162.79	162.34	162.79	185373.0
2018-04-16 09:00:00	QQQ	ETF	162.77	162.79	162.41	162.46	281517.0
2018-04-16 09:30:00	QQQ	ETF	162.45	162.58	161.6	161.81	3104244.0
2018-04-16 10:00:00	QQQ	ETF	161.82	162.5	161.81	162.45	2071112.0
2018-04-16 10:30:00	QQQ	ETF	162.47	162.56	161.83	162.05	1150141.0
2018-04-16 11:00:00	QQQ	ETF	162.06	162.28	161.48	162.049	1318522.0
2018-04-16 11:30:00	QQQ	ETF	162.05	162.2892	161.89	162.2559	843363.0
2018-04-16 12:00:00	QQQ	ETF	162.27	162.61	162.27	162.441	1271781.0
2018-04-16 12:30:00	QQQ	ETF	162.45	162.97	162.3	162.905	1330130.0

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

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