PREVIEW / etf_30min / 2017-05-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-05.parquet
  size:    429 KB
  rows:    14,677

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-05-05 04:00:00	SPY	ETF	238.6	238.76	238.57	238.76	1817.0
2017-05-05 04:30:00	SPY	ETF	238.79	238.81	238.76	238.79	4903.0
2017-05-05 05:00:00	SPY	ETF	238.81	238.84	238.76	238.76	3007.0
2017-05-05 05:30:00	SPY	ETF	238.76	238.84	238.76	238.79	2711.0
2017-05-05 06:00:00	SPY	ETF	238.79	238.81	238.79	238.81	1090.0
2017-05-05 06:30:00	SPY	ETF	238.76	238.86	238.75	238.86	11517.0
2017-05-05 07:00:00	SPY	ETF	238.83	238.89	238.82	238.86	59708.0
2017-05-05 07:30:00	SPY	ETF	238.82	238.86	238.79	238.8	47046.0
2017-05-05 08:00:00	SPY	ETF	238.84	238.85	238.69	238.81	133008.0
2017-05-05 08:30:00	SPY	ETF	238.86	239.23	238.75	239.05	792380.0
2017-05-05 09:00:00	SPY	ETF	239.05	239.22	239.05	239.19	547939.0
2017-05-05 09:30:00	SPY	ETF	239.19	239.31	238.84	238.86	4901124.0
2017-05-05 10:00:00	SPY	ETF	238.84	239.06	238.73	238.88	2937051.0
2017-05-05 10:30:00	SPY	ETF	238.881	238.96	238.68	238.895	2486504.0
2017-05-05 11:00:00	SPY	ETF	238.89	238.99	238.785	238.8001	2468569.0
2017-05-05 11:30:00	SPY	ETF	238.81	239.09	238.78	239.05	2369997.0
2017-05-05 12:00:00	SPY	ETF	239.06	239.12	238.9	238.91	2399688.0
2017-05-05 12:30:00	SPY	ETF	238.92	238.95	238.71	238.95	3628958.0
2017-05-05 13:00:00	SPY	ETF	238.95	239.01	238.85	238.98	2224466.0
2017-05-05 13:30:00	SPY	ETF	238.98	239.12	238.95	239.1	1935722.0
2017-05-05 14:00:00	SPY	ETF	239.11	239.25	239.05	239.1201	2291509.0
2017-05-05 14:30:00	SPY	ETF	239.13	239.39	239.1	239.24	3051485.0
2017-05-05 15:00:00	SPY	ETF	239.24	239.41	239.15	239.335	4639002.0
2017-05-05 15:30:00	SPY	ETF	239.34	239.72	239.33	239.72	12599912.0
2017-05-05 16:00:00	SPY	ETF	239.72	239.95	239.6	239.89	8042756.0
2017-05-05 16:30:00	SPY	ETF	239.9	240.04	239.83	240.04	668065.0
2017-05-05 17:00:00	SPY	ETF	240.02	240.05	239.52	239.99	1441874.0
2017-05-05 17:30:00	SPY	ETF	240.0	240.0	239.9	239.98	139651.0
2017-05-05 18:00:00	SPY	ETF	239.98	240.06	239.98	240.03	31439.0
2017-05-05 18:30:00	SPY	ETF	240.03	240.06	239.69	239.7	214212.0
2017-05-05 19:00:00	SPY	ETF	239.7	239.79	239.65	239.72	102475.0
2017-05-05 19:30:00	SPY	ETF	239.73	239.95	239.72	239.95	62121.0
2017-05-05 04:00:00	QQQ	ETF	137.0	137.0	137.0	137.0	700.0
2017-05-05 04:30:00	QQQ	ETF	137.12	137.12	137.12	137.12	499.0
2017-05-05 05:00:00	QQQ	ETF	137.12	137.13	137.07	137.07	5999.0
2017-05-05 05:30:00	QQQ	ETF	137.07	137.07	137.07	137.07	1000.0
2017-05-05 06:30:00	QQQ	ETF	137.16	137.16	137.16	137.16	200.0
2017-05-05 07:00:00	QQQ	ETF	137.15	137.16	137.15	137.15	3668.0
2017-05-05 07:30:00	QQQ	ETF	137.15	137.16	137.12	137.15	24112.0
2017-05-05 08:00:00	QQQ	ETF	137.12	137.21	137.09	137.14	39664.0
2017-05-05 08:30:00	QQQ	ETF	137.22	137.41	137.18	137.32	112414.0
2017-05-05 09:00:00	QQQ	ETF	137.36	137.4	137.34	137.4	118468.0
2017-05-05 09:30:00	QQQ	ETF	137.39	137.41	137.09	137.1	1254798.0
2017-05-05 10:00:00	QQQ	ETF	137.095	137.15	136.93	136.99	810019.0
2017-05-05 10:30:00	QQQ	ETF	136.99	137.05	136.88	136.98	571250.0
2017-05-05 11:00:00	QQQ	ETF	136.98	137.04	136.9	136.92	575831.0
2017-05-05 11:30:00	QQQ	ETF	136.93	137.14	136.91	137.12	513394.0
2017-05-05 12:00:00	QQQ	ETF	137.125	137.19	137.1	137.1	721441.0
2017-05-05 12:30:00	QQQ	ETF	137.1053	137.159	136.98	137.12	458314.0
2017-05-05 13:00:00	QQQ	ETF	137.115	137.23	137.1	137.2	414510.0

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

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