PREVIEW / etf_30min / 2018-04-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-06.parquet
  size:    467 KB
  rows:    15,989

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-06 04:00:00	SPY	ETF	263.23	263.69	263.23	263.69	10775.0
2018-04-06 04:30:00	SPY	ETF	263.64	263.71	263.5	263.63	14865.0
2018-04-06 05:00:00	SPY	ETF	263.65	263.86	263.39	263.81	17215.0
2018-04-06 05:30:00	SPY	ETF	263.78	263.96	263.65	263.91	25537.0
2018-04-06 06:00:00	SPY	ETF	263.88	264.24	263.88	264.24	35595.0
2018-04-06 06:30:00	SPY	ETF	264.24	264.33	263.84	263.95	56868.0
2018-04-06 07:00:00	SPY	ETF	263.96	264.02	263.05	263.45	211673.0
2018-04-06 07:30:00	SPY	ETF	263.45	263.6	262.88	262.91	179053.0
2018-04-06 08:00:00	SPY	ETF	263.46	263.96	262.3	263.5	572225.0
2018-04-06 08:30:00	SPY	ETF	263.41	265.64	262.81	263.78	1605673.0
2018-04-06 09:00:00	SPY	ETF	263.76	265.64	263.11	263.46	955794.0
2018-04-06 09:30:00	SPY	ETF	263.42	265.11	263.11	264.61	11071924.0
2018-04-06 10:00:00	SPY	ETF	264.62	264.88	264.08	264.13	5694688.0
2018-04-06 10:30:00	SPY	ETF	264.13	264.31	262.62	262.89	10115023.0
2018-04-06 11:00:00	SPY	ETF	262.9	262.91	262.03	262.53	8394427.0
2018-04-06 11:30:00	SPY	ETF	262.53	263.26	262.34	263.0884	5306298.0
2018-04-06 12:00:00	SPY	ETF	263.06	263.09	261.76	261.81	5553749.0
2018-04-06 12:30:00	SPY	ETF	261.82	263.41	261.7	263.37	5587454.0
2018-04-06 13:00:00	SPY	ETF	263.35	263.35	262.02	262.64	5349102.0
2018-04-06 13:30:00	SPY	ETF	262.65	262.89	260.36	260.395	9951666.0
2018-04-06 14:00:00	SPY	ETF	260.39	260.65	259.5	259.61	13111677.0
2018-04-06 14:30:00	SPY	ETF	259.58	260.04	258.1	258.46	15983133.0
2018-04-06 15:00:00	SPY	ETF	258.47	259.57	258.0	258.85	17369217.0
2018-04-06 15:30:00	SPY	ETF	258.87	260.69	258.73	259.8	30631906.0
2018-04-06 16:00:00	SPY	ETF	259.78	262.4	259.71	259.99	26732890.0
2018-04-06 16:30:00	SPY	ETF	259.99	260.02	259.87	260.01	453628.0
2018-04-06 17:00:00	SPY	ETF	260.02	260.07	259.72	259.92	646306.0
2018-04-06 17:30:00	SPY	ETF	259.92	259.92	259.61	259.64	273985.0
2018-04-06 18:00:00	SPY	ETF	259.64	259.64	259.45	259.51	34775.0
2018-04-06 18:30:00	SPY	ETF	259.5	259.55	259.47	259.47	26349.0
2018-04-06 19:00:00	SPY	ETF	259.54	259.54	259.46	259.5	8443.0
2018-04-06 19:30:00	SPY	ETF	259.46	259.52	259.45	259.46	8829.0
2018-04-06 04:00:00	QQQ	ETF	159.0	159.24	158.98	159.24	5577.0
2018-04-06 04:30:00	QQQ	ETF	159.21	159.32	159.14	159.26	4206.0
2018-04-06 05:00:00	QQQ	ETF	159.18	159.25	158.98	159.23	6225.0
2018-04-06 05:30:00	QQQ	ETF	159.22	159.48	159.15	159.41	7771.0
2018-04-06 06:00:00	QQQ	ETF	159.55	159.68	159.48	159.67	15666.0
2018-04-06 06:30:00	QQQ	ETF	159.7	159.7	159.35	159.39	11600.0
2018-04-06 07:00:00	QQQ	ETF	159.45	159.45	158.62	158.97	55154.0
2018-04-06 07:30:00	QQQ	ETF	158.93	159.0	158.45	158.48	73440.0
2018-04-06 08:00:00	QQQ	ETF	158.52	159.27	158.47	159.05	216618.0
2018-04-06 08:30:00	QQQ	ETF	159.03	159.6	158.53	159.18	468087.0
2018-04-06 09:00:00	QQQ	ETF	159.2	159.26	158.72	158.92	195991.0
2018-04-06 09:30:00	QQQ	ETF	158.94	160.4601	158.62	160.1	5697305.0
2018-04-06 10:00:00	QQQ	ETF	160.11	160.27	159.5	159.68	2186972.0
2018-04-06 10:30:00	QQQ	ETF	159.67	159.8275	158.57	158.979	3119308.0
2018-04-06 11:00:00	QQQ	ETF	158.95	159.1	158.36	158.89	2787883.0
2018-04-06 11:30:00	QQQ	ETF	158.91	159.579	158.79	159.43	1636841.0
2018-04-06 12:00:00	QQQ	ETF	159.43	159.4948	158.435	158.48	1489606.0
2018-04-06 12:30:00	QQQ	ETF	158.4752	159.49	158.39	159.43	2728110.0

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

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