PREVIEW / etf_30min / 2018-02-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-09.parquet
  size:    527 KB
  rows:    18,229

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-02-09 04:00:00	SPY	ETF	261.08	261.16	260.56	260.61	38142.0
2018-02-09 04:30:00	SPY	ETF	260.53	260.95	260.5	260.89	23701.0
2018-02-09 05:00:00	SPY	ETF	260.78	260.99	260.41	260.99	10352.0
2018-02-09 05:30:00	SPY	ETF	260.99	261.23	260.7	260.9	18212.0
2018-02-09 06:00:00	SPY	ETF	260.9	261.05	260.04	260.16	39085.0
2018-02-09 06:30:00	SPY	ETF	260.1	260.11	259.17	260.0	276795.0
2018-02-09 07:00:00	SPY	ETF	260.0	260.5	258.64	258.64	278509.0
2018-02-09 07:30:00	SPY	ETF	258.66	259.09	257.92	258.32	394169.0
2018-02-09 08:00:00	SPY	ETF	258.325	261.13	257.95	259.3	535643.0
2018-02-09 08:30:00	SPY	ETF	259.34	261.03	259.06	260.83	871316.0
2018-02-09 09:00:00	SPY	ETF	260.8	261.08	260.16	260.78	2706447.0
2018-02-09 09:30:00	SPY	ETF	260.8	261.76	259.28	260.75	20400598.0
2018-02-09 10:00:00	SPY	ETF	260.76	261.21	259.57	259.99	13663814.0
2018-02-09 10:30:00	SPY	ETF	259.97	260.26	256.5	258.49	19085271.0
2018-02-09 11:00:00	SPY	ETF	258.5	259.66	257.6	258.07	10293632.0
2018-02-09 11:30:00	SPY	ETF	258.06	259.03	256.67	256.75	6943402.0
2018-02-09 12:00:00	SPY	ETF	256.749	257.05	254.76	254.835	17270136.0
2018-02-09 12:30:00	SPY	ETF	254.8402	256.44	253.76	256.39	16951387.0
2018-02-09 13:00:00	SPY	ETF	256.36	256.36	253.58	253.96	16583607.0
2018-02-09 13:30:00	SPY	ETF	253.99	256.9	252.92	255.73	20531067.0
2018-02-09 14:00:00	SPY	ETF	255.71	260.76	255.62	258.7	24862564.0
2018-02-09 14:30:00	SPY	ETF	258.73	259.77	257.79	258.47	13687239.0
2018-02-09 15:00:00	SPY	ETF	258.45	259.74	256.55	259.19	18695766.0
2018-02-09 15:30:00	SPY	ETF	259.19	263.61	259.03	261.67	51173519.0
2018-02-09 16:00:00	SPY	ETF	261.69	262.2	261.19	261.66	15276029.0
2018-02-09 16:30:00	SPY	ETF	261.66	262.15	261.64	262.05	3943875.0
2018-02-09 17:00:00	SPY	ETF	262.0	262.48	261.6647	262.39	4572427.0
2018-02-09 17:30:00	SPY	ETF	262.35	262.49	262.14	262.4	89128.0
2018-02-09 18:00:00	SPY	ETF	262.4	262.45	262.34	262.38	21966.0
2018-02-09 18:30:00	SPY	ETF	262.39	262.42	262.36	262.4	11550.0
2018-02-09 19:00:00	SPY	ETF	262.41	262.44	262.3	262.3	10133.0
2018-02-09 19:30:00	SPY	ETF	262.35	262.42	261.5	262.42	226853.0
2018-02-09 04:00:00	QQQ	ETF	155.04	155.25	154.81	154.81	52910.0
2018-02-09 04:30:00	QQQ	ETF	154.97	155.14	154.87	155.12	19150.0
2018-02-09 05:00:00	QQQ	ETF	155.0	155.06	154.73	154.9	24250.0
2018-02-09 05:30:00	QQQ	ETF	155.05	155.24	154.76	154.96	12368.0
2018-02-09 06:00:00	QQQ	ETF	154.97	155.0	154.4	154.5	24566.0
2018-02-09 06:30:00	QQQ	ETF	154.47	154.6	154.0	154.6	31105.0
2018-02-09 07:00:00	QQQ	ETF	154.66	154.83	153.87	153.87	162648.0
2018-02-09 07:30:00	QQQ	ETF	153.99	154.44	153.79	154.08	281715.0
2018-02-09 08:00:00	QQQ	ETF	154.26	155.0	153.25	154.69	230897.0
2018-02-09 08:30:00	QQQ	ETF	154.67	155.38	154.5	155.19	431887.0
2018-02-09 09:00:00	QQQ	ETF	155.19	155.77	154.95	155.63	409285.0
2018-02-09 09:30:00	QQQ	ETF	155.63	156.46	154.705	155.8987	8559963.0
2018-02-09 10:00:00	QQQ	ETF	155.89	156.33	154.71	155.4375	5822813.0
2018-02-09 10:30:00	QQQ	ETF	155.45	155.78	153.07	154.2163	7408769.0
2018-02-09 11:00:00	QQQ	ETF	154.21	155.12	153.5	153.89	4723579.0
2018-02-09 11:30:00	QQQ	ETF	153.88	154.58	152.96	153.02	3371046.0
2018-02-09 12:00:00	QQQ	ETF	153.01	153.245	151.4055	151.44	7328002.0
2018-02-09 12:30:00	QQQ	ETF	151.44	152.46	150.27	152.45	6810758.0

> showing 50 of 18,229 rows — these rows as CSV

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