PREVIEW / etf_30min / 2017-02-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-14.parquet
  size:    438 KB
  rows:    14,761

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-14 04:00:00	SPY	ETF	232.75	232.75	232.59	232.59	1900.0
2017-02-14 04:30:00	SPY	ETF	232.59	232.64	232.57	232.64	7050.0
2017-02-14 05:00:00	SPY	ETF	232.59	232.59	232.59	232.59	1001.0
2017-02-14 05:30:00	SPY	ETF	232.6	232.6	232.59	232.59	302.0
2017-02-14 06:00:00	SPY	ETF	232.77	232.79	232.66	232.69	2988.0
2017-02-14 06:30:00	SPY	ETF	232.64	232.8	232.64	232.8	3803.0
2017-02-14 07:00:00	SPY	ETF	232.76	232.81	232.75	232.81	38254.0
2017-02-14 07:30:00	SPY	ETF	232.77	232.83	232.76	232.77	26804.0
2017-02-14 08:00:00	SPY	ETF	232.79	232.92	232.5	232.91	138086.0
2017-02-14 08:30:00	SPY	ETF	232.9	232.92	232.68	232.71	114662.0
2017-02-14 09:00:00	SPY	ETF	232.71	232.74	232.52	232.52	428935.0
2017-02-14 09:30:00	SPY	ETF	232.56	232.79	232.4	232.47	5779823.0
2017-02-14 10:00:00	SPY	ETF	232.47	232.66	232.24	232.46	5611983.0
2017-02-14 10:30:00	SPY	ETF	232.46	232.55	232.17	232.49	3888510.0
2017-02-14 11:00:00	SPY	ETF	232.49	232.66	232.16	232.62	4371357.0
2017-02-14 11:30:00	SPY	ETF	232.63	232.82	232.53	232.77	2632061.0
2017-02-14 12:00:00	SPY	ETF	232.76	232.86	232.71	232.81	2276822.0
2017-02-14 12:30:00	SPY	ETF	232.82	233.23	232.77	233.175	3684394.0
2017-02-14 13:00:00	SPY	ETF	233.17	233.43	233.14	233.37	2776182.0
2017-02-14 13:30:00	SPY	ETF	233.377	233.53	233.27	233.46	5248711.0
2017-02-14 14:00:00	SPY	ETF	233.46	233.67	233.41	233.51	5440593.0
2017-02-14 14:30:00	SPY	ETF	233.5	233.53	233.29	233.345	5151388.0
2017-02-14 15:00:00	SPY	ETF	233.3465	233.47	233.33	233.45	3978849.0
2017-02-14 15:30:00	SPY	ETF	233.45	233.71	233.36	233.71	10928957.0
2017-02-14 16:00:00	SPY	ETF	233.7	233.94	233.64	233.89	5373848.0
2017-02-14 16:30:00	SPY	ETF	233.89	233.91	233.7	233.74	349828.0
2017-02-14 17:00:00	SPY	ETF	233.74	233.83	232.7772	233.73	1054968.0
2017-02-14 17:30:00	SPY	ETF	233.73	233.85	233.71	233.72	463852.0
2017-02-14 18:00:00	SPY	ETF	233.72	233.74	233.66	233.69	69124.0
2017-02-14 18:30:00	SPY	ETF	233.69	233.71	233.66	233.66	9651.0
2017-02-14 19:00:00	SPY	ETF	233.67	233.71	233.65	233.69	13704.0
2017-02-14 19:30:00	SPY	ETF	233.67	233.72	233.65	233.72	29289.0
2017-02-14 04:30:00	QQQ	ETF	128.12	128.12	128.12	128.12	350.0
2017-02-14 05:30:00	QQQ	ETF	128.14	128.14	128.1	128.11	3349.0
2017-02-14 06:00:00	QQQ	ETF	128.24	128.24	128.22	128.23	10398.0
2017-02-14 06:30:00	QQQ	ETF	128.16	128.16	128.16	128.16	1085.0
2017-02-14 07:00:00	QQQ	ETF	128.2	128.2	128.2	128.2	300.0
2017-02-14 07:30:00	QQQ	ETF	128.2	128.21	128.2	128.2	15024.0
2017-02-14 08:00:00	QQQ	ETF	128.16	128.21	128.14	128.21	21917.0
2017-02-14 08:30:00	QQQ	ETF	128.21	128.21	128.11	128.14	17342.0
2017-02-14 09:00:00	QQQ	ETF	128.12	128.16	128.09	128.13	57197.0
2017-02-14 09:30:00	QQQ	ETF	128.15	128.15	127.96	128.078	2862948.0
2017-02-14 10:00:00	QQQ	ETF	128.07	128.135	127.88	128.02	1374638.0
2017-02-14 10:30:00	QQQ	ETF	128.019	128.04	127.74	127.91	853921.0
2017-02-14 11:00:00	QQQ	ETF	127.91	128.03	127.7628	127.99	646082.0
2017-02-14 11:30:00	QQQ	ETF	128.0	128.19	127.98	128.14	566393.0
2017-02-14 12:00:00	QQQ	ETF	128.15	128.2202	128.12	128.18	515065.0
2017-02-14 12:30:00	QQQ	ETF	128.1757	128.369	128.15	128.34	656775.0
2017-02-14 13:00:00	QQQ	ETF	128.34	128.46	128.31	128.42	907647.0
2017-02-14 13:30:00	QQQ	ETF	128.4228	128.48	128.38	128.45	1104590.0

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

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