PREVIEW / etf_30min / 2017-06-16

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-16.parquet
  size:    413 KB
  rows:    14,339

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-06-16 04:00:00	SPY	ETF	243.16	243.18	243.0	243.02	9560.0
2017-06-16 04:30:00	SPY	ETF	243.01	243.01	242.94	242.94	2500.0
2017-06-16 05:00:00	SPY	ETF	242.93	243.08	242.92	243.02	2890.0
2017-06-16 05:30:00	SPY	ETF	242.97	243.06	242.92	242.92	13000.0
2017-06-16 06:00:00	SPY	ETF	242.94	243.08	242.94	243.08	12000.0
2017-06-16 06:30:00	SPY	ETF	243.06	243.06	242.97	243.0	14230.0
2017-06-16 07:00:00	SPY	ETF	243.05	243.1	243.02	243.03	164687.0
2017-06-16 07:30:00	SPY	ETF	243.08	243.14	243.04	243.06	119184.0
2017-06-16 08:00:00	SPY	ETF	243.06	243.06	242.9	242.95	129951.0
2017-06-16 08:30:00	SPY	ETF	242.93	242.95	242.65	242.7	331384.0
2017-06-16 09:00:00	SPY	ETF	242.69	242.84	242.64	242.78	849306.0
2017-06-16 09:30:00	SPY	ETF	242.77	242.83	241.77	242.1992	12236556.0
2017-06-16 10:00:00	SPY	ETF	242.18	242.24	241.745	241.895	4871953.0
2017-06-16 10:30:00	SPY	ETF	241.89	242.08	241.6337	241.8311	5300499.0
2017-06-16 11:00:00	SPY	ETF	241.84	242.03	241.72	242.01	2495180.0
2017-06-16 11:30:00	SPY	ETF	242.02	242.275	241.97	242.275	3946780.0
2017-06-16 12:00:00	SPY	ETF	242.275	242.41	242.275	242.4	8355279.0
2017-06-16 12:30:00	SPY	ETF	242.39	242.439	242.24	242.26	1815997.0
2017-06-16 13:00:00	SPY	ETF	242.27	242.37	242.1	242.235	1795623.0
2017-06-16 13:30:00	SPY	ETF	242.235	242.83	242.11	242.33	1472702.0
2017-06-16 14:00:00	SPY	ETF	242.33	242.43	242.26	242.33	3513014.0
2017-06-16 14:30:00	SPY	ETF	242.325	242.83	242.26	242.43	3191742.0
2017-06-16 15:00:00	SPY	ETF	242.435	242.53	242.195	242.31	4040672.0
2017-06-16 15:30:00	SPY	ETF	242.32	242.68	242.24	242.63	12763656.0
2017-06-16 16:00:00	SPY	ETF	242.63	242.77	242.2396	242.72	12450793.0
2017-06-16 16:30:00	SPY	ETF	242.73	242.99	242.72	242.98	998980.0
2017-06-16 17:00:00	SPY	ETF	242.98	243.04	242.2	243.04	2061267.0
2017-06-16 17:30:00	SPY	ETF	243.04	243.12	241.8273	243.05	667371.0
2017-06-16 18:00:00	SPY	ETF	243.06	243.08	243.06	243.06	14313.0
2017-06-16 18:30:00	SPY	ETF	243.08	243.08	243.04	243.05	7345.0
2017-06-16 19:00:00	SPY	ETF	243.07	243.08	243.06	243.08	7722.0
2017-06-16 19:30:00	SPY	ETF	243.07	243.09	243.05	243.09	32819.0
2017-06-16 04:00:00	QQQ	ETF	139.18	139.19	139.04	139.04	20100.0
2017-06-16 04:30:00	QQQ	ETF	138.99	138.99	138.8	138.8	1600.0
2017-06-16 05:00:00	QQQ	ETF	138.88	138.95	138.88	138.95	660.0
2017-06-16 05:30:00	QQQ	ETF	138.97	138.97	138.88	138.88	5251.0
2017-06-16 06:00:00	QQQ	ETF	138.9	139.01	138.9	139.01	4161.0
2017-06-16 06:30:00	QQQ	ETF	138.99	138.99	138.95	138.95	7012.0
2017-06-16 07:00:00	QQQ	ETF	138.98	139.03	138.97	138.99	7919.0
2017-06-16 07:30:00	QQQ	ETF	139.01	139.02	138.98	138.98	23028.0
2017-06-16 08:00:00	QQQ	ETF	138.99	138.99	138.81	138.86	44201.0
2017-06-16 08:30:00	QQQ	ETF	138.85	138.85	138.5	138.51	149710.0
2017-06-16 09:00:00	QQQ	ETF	138.5	138.77	138.34	138.71	413327.0
2017-06-16 09:30:00	QQQ	ETF	138.72	138.72	138.04	138.6	5917074.0
2017-06-16 10:00:00	QQQ	ETF	138.6	138.605	137.86	137.99	3456435.0
2017-06-16 10:30:00	QQQ	ETF	137.99	138.16	137.67	137.86	2732381.0
2017-06-16 11:00:00	QQQ	ETF	137.855	138.05	137.638	138.05	1958193.0
2017-06-16 11:30:00	QQQ	ETF	138.05	138.26	138.005	138.2365	2036593.0
2017-06-16 12:00:00	QQQ	ETF	138.25	138.37	138.215	138.37	1092141.0
2017-06-16 12:30:00	QQQ	ETF	138.37	138.4	138.17	138.23	1349185.0

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

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