PREVIEW / etf_30min / 2017-02-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-06.parquet
  size:    431 KB
  rows:    14,810

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
2017-02-06 04:00:00	SPY	ETF	229.37	229.49	229.37	229.46	2910.0
2017-02-06 04:30:00	SPY	ETF	229.44	229.46	229.39	229.46	7122.0
2017-02-06 05:00:00	SPY	ETF	229.49	229.54	229.49	229.54	800.0
2017-02-06 05:30:00	SPY	ETF	229.51	229.54	229.49	229.49	5750.0
2017-02-06 06:00:00	SPY	ETF	229.49	229.51	229.26	229.26	5550.0
2017-02-06 06:30:00	SPY	ETF	229.25	229.27	229.22	229.24	12700.0
2017-02-06 07:00:00	SPY	ETF	229.24	229.27	229.15	229.17	35675.0
2017-02-06 07:30:00	SPY	ETF	229.17	229.2	228.98	228.98	22503.0
2017-02-06 08:00:00	SPY	ETF	228.95	229.28	228.77	228.88	240045.0
2017-02-06 08:30:00	SPY	ETF	228.85	229.042	228.58	228.81	290692.0
2017-02-06 09:00:00	SPY	ETF	228.82	228.975	228.82	228.86	224226.0
2017-02-06 09:30:00	SPY	ETF	228.87	229.255	228.82	229.14	6573696.0
2017-02-06 10:00:00	SPY	ETF	229.14	229.326	229.03	229.22	3585465.0
2017-02-06 10:30:00	SPY	ETF	229.22	229.23	228.915	228.93	3326326.0
2017-02-06 11:00:00	SPY	ETF	228.92	229.26	228.89	229.194	2498679.0
2017-02-06 11:30:00	SPY	ETF	229.19	229.22	228.95	229.02	2654689.0
2017-02-06 12:00:00	SPY	ETF	229.01	229.0499	228.92	228.99	1291071.0
2017-02-06 12:30:00	SPY	ETF	228.995	229.0	228.72	228.74	3369649.0
2017-02-06 13:00:00	SPY	ETF	228.74	228.8	228.545	228.7	3218173.0
2017-02-06 13:30:00	SPY	ETF	228.7	228.83	228.54	228.8	3617800.0
2017-02-06 14:00:00	SPY	ETF	228.8	228.805	228.66	228.73	2815115.0
2017-02-06 14:30:00	SPY	ETF	228.72	228.84	228.66	228.765	4520637.0
2017-02-06 15:00:00	SPY	ETF	228.77	228.89	228.75	228.815	2864436.0
2017-02-06 15:30:00	SPY	ETF	228.82	228.97	228.75	228.97	7417434.0
2017-02-06 16:00:00	SPY	ETF	228.97	228.99	228.77	228.8	3262647.0
2017-02-06 16:30:00	SPY	ETF	228.78	228.84	228.74	228.84	80738.0
2017-02-06 17:00:00	SPY	ETF	228.81	228.93	228.76	228.76	1325663.0
2017-02-06 17:30:00	SPY	ETF	228.78	228.93	228.77	228.77	15507.0
2017-02-06 18:00:00	SPY	ETF	228.77	228.83	228.76	228.83	8597.0
2017-02-06 18:30:00	SPY	ETF	228.83	228.9	228.83	228.86	10880.0
2017-02-06 19:00:00	SPY	ETF	228.85	228.86	228.8	228.8	2257.0
2017-02-06 19:30:00	SPY	ETF	228.78	228.79	228.62	228.7	32153.0
2017-02-06 04:00:00	QQQ	ETF	125.59	125.59	125.59	125.59	4000.0
2017-02-06 05:30:00	QQQ	ETF	125.76	125.77	125.76	125.77	5114.0
2017-02-06 06:00:00	QQQ	ETF	125.74	125.76	125.65	125.65	11400.0
2017-02-06 07:00:00	QQQ	ETF	125.62	125.62	125.59	125.59	6798.0
2017-02-06 07:30:00	QQQ	ETF	125.59	125.59	125.5	125.5	2208.0
2017-02-06 08:00:00	QQQ	ETF	125.47	125.47	125.39	125.4	37828.0
2017-02-06 08:30:00	QQQ	ETF	125.37	125.42	125.3	125.4	24218.0
2017-02-06 09:00:00	QQQ	ETF	125.42	125.52	125.42	125.43	184361.0
2017-02-06 09:30:00	QQQ	ETF	125.42	125.61	125.35	125.54	1596971.0
2017-02-06 10:00:00	QQQ	ETF	125.55	125.66	125.46	125.6366	653263.0
2017-02-06 10:30:00	QQQ	ETF	125.631	125.68	125.539	125.55	663766.0
2017-02-06 11:00:00	QQQ	ETF	125.54	125.85	125.53	125.83	628122.0
2017-02-06 11:30:00	QQQ	ETF	125.83	125.83	125.68	125.7361	644841.0
2017-02-06 12:00:00	QQQ	ETF	125.73	125.7565	125.68	125.7293	515460.0
2017-02-06 12:30:00	QQQ	ETF	125.725	125.73	125.62	125.645	317006.0
2017-02-06 13:00:00	QQQ	ETF	125.6407	125.68	125.5007	125.595	390684.0
2017-02-06 13:30:00	QQQ	ETF	125.59	125.665	125.5	125.65	328243.0
2017-02-06 14:00:00	QQQ	ETF	125.659	125.68	125.59	125.65	377603.0

> showing 50 of 14,810 rows — these rows as CSV

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