PREVIEW / etf_30min / 2018-02-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-06.parquet
  size:    548 KB
  rows:    19,191

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-06 04:00:00	SPY	ETF	263.5	264.98	263.06	263.49	216218.0
2018-02-06 04:30:00	SPY	ETF	263.53	263.53	261.51	261.71	134138.0
2018-02-06 05:00:00	SPY	ETF	261.82	261.82	259.71	259.95	323834.0
2018-02-06 05:30:00	SPY	ETF	259.83	262.27	259.83	261.93	456101.0
2018-02-06 06:00:00	SPY	ETF	261.94	262.17	259.91	260.1	129052.0
2018-02-06 06:30:00	SPY	ETF	260.11	260.26	257.6	258.0	355472.0
2018-02-06 07:00:00	SPY	ETF	258.0	261.38	256.98	260.11	1138166.0
2018-02-06 07:30:00	SPY	ETF	260.0	260.5	259.12	260.1	713924.0
2018-02-06 08:00:00	SPY	ETF	260.02	262.66	257.15	257.89	1953864.0
2018-02-06 08:30:00	SPY	ETF	257.9	260.9	257.0	260.46	2457677.0
2018-02-06 09:00:00	SPY	ETF	260.44	262.05	257.67	259.92	3465530.0
2018-02-06 09:30:00	SPY	ETF	259.94	267.78	258.7	265.79	49943526.0
2018-02-06 10:00:00	SPY	ETF	265.82	267.83	262.56	263.3	39747926.0
2018-02-06 10:30:00	SPY	ETF	263.32	264.95	261.38	263.75	28253901.0
2018-02-06 11:00:00	SPY	ETF	263.77	264.18	262.23	262.76	22341328.0
2018-02-06 11:30:00	SPY	ETF	262.76	264.2	261.57	263.19	16584761.0
2018-02-06 12:00:00	SPY	ETF	263.2	265.51	263.19	265.34	18526446.0
2018-02-06 12:30:00	SPY	ETF	265.3649	266.47	264.34	264.99	15573175.0
2018-02-06 13:00:00	SPY	ETF	265.01	265.17	263.41	264.66	17821406.0
2018-02-06 13:30:00	SPY	ETF	264.67	264.7	262.64	262.845	12800878.0
2018-02-06 14:00:00	SPY	ETF	262.845	263.61	262.22	262.74	17442289.0
2018-02-06 14:30:00	SPY	ETF	262.745	267.0	262.43	266.77	19318722.0
2018-02-06 15:00:00	SPY	ETF	266.76	269.0	266.7	268.04	22797934.0
2018-02-06 15:30:00	SPY	ETF	268.05	269.7	267.22	269.18	33213698.0
2018-02-06 16:00:00	SPY	ETF	269.19	269.63	268.53	268.91	20965001.0
2018-02-06 16:30:00	SPY	ETF	268.91	269.33	265.1012	268.04	3419559.0
2018-02-06 17:00:00	SPY	ETF	268.07	269.13	259.5119	268.72	714251.0
2018-02-06 17:30:00	SPY	ETF	268.7	269.1301	268.45	268.45	646391.0
2018-02-06 18:00:00	SPY	ETF	268.45	269.43	268.41	268.53	585522.0
2018-02-06 18:30:00	SPY	ETF	268.49	268.5	267.84	268.5	64911.0
2018-02-06 19:00:00	SPY	ETF	268.49	269.3	268.1	268.23	76373.0
2018-02-06 19:30:00	SPY	ETF	268.22	268.89	265.1954	268.89	32257.0
2018-02-06 04:00:00	QQQ	ETF	158.27	158.96	157.95	158.43	106710.0
2018-02-06 04:30:00	QQQ	ETF	158.36	158.51	157.43	157.6	29140.0
2018-02-06 05:00:00	QQQ	ETF	157.6	157.68	156.61	156.81	50465.0
2018-02-06 05:30:00	QQQ	ETF	156.7	157.85	156.65	157.49	35981.0
2018-02-06 06:00:00	QQQ	ETF	157.21	157.5	155.93	155.93	69689.0
2018-02-06 06:30:00	QQQ	ETF	155.93	156.2	154.83	155.2	170234.0
2018-02-06 07:00:00	QQQ	ETF	155.09	156.72	154.77	156.21	229572.0
2018-02-06 07:30:00	QQQ	ETF	156.23	156.61	155.78	156.14	300450.0
2018-02-06 08:00:00	QQQ	ETF	156.18	157.9	154.76	155.3	841687.0
2018-02-06 08:30:00	QQQ	ETF	155.3	156.8	154.84	156.8	495539.0
2018-02-06 09:00:00	QQQ	ETF	156.8	158.38	155.71	155.96	823344.0
2018-02-06 09:30:00	QQQ	ETF	155.96	160.66	155.1	159.35	18049847.0
2018-02-06 10:00:00	QQQ	ETF	159.3799	160.68	157.15	157.66	11312221.0
2018-02-06 10:30:00	QQQ	ETF	157.665	158.96	156.35	158.11	9690089.0
2018-02-06 11:00:00	QQQ	ETF	158.12	158.42	157.28	157.85	7401490.0
2018-02-06 11:30:00	QQQ	ETF	157.83	158.78	156.95	158.2	5477194.0
2018-02-06 12:00:00	QQQ	ETF	158.2	159.83	158.2	159.74	5948751.0
2018-02-06 12:30:00	QQQ	ETF	159.7219	160.54	159.15	159.77	6169760.0

> showing 50 of 19,191 rows — these rows as CSV

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