PREVIEW / etf_30min / 2015-11-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-03.parquet
  size:    390 KB
  rows:    13,120

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
2015-11-03 04:00:00	SPY	ETF	209.92	209.92	209.83	209.91	700.0
2015-11-03 04:30:00	SPY	ETF	209.89	209.98	209.85	209.91	26444.0
2015-11-03 05:00:00	SPY	ETF	209.99	209.99	209.83	209.83	8549.0
2015-11-03 05:30:00	SPY	ETF	209.84	209.87	209.8	209.8	2066.0
2015-11-03 06:00:00	SPY	ETF	209.87	209.87	209.74	209.82	9791.0
2015-11-03 06:30:00	SPY	ETF	209.83	209.87	209.67	209.68	15903.0
2015-11-03 07:00:00	SPY	ETF	209.71	209.77	209.56	209.62	119279.0
2015-11-03 07:30:00	SPY	ETF	209.61	209.75	209.59	209.69	96122.0
2015-11-03 08:00:00	SPY	ETF	209.68	210.39	209.54	209.63	179345.0
2015-11-03 08:30:00	SPY	ETF	209.63	209.87	209.63	209.77	241909.0
2015-11-03 09:00:00	SPY	ETF	209.77	210.0	209.77	209.98	305168.0
2015-11-03 09:30:00	SPY	ETF	209.97	210.21	209.7	209.87	10331997.0
2015-11-03 10:00:00	SPY	ETF	209.87	210.4	209.8611	210.28	5940279.0
2015-11-03 10:30:00	SPY	ETF	210.27	210.54	210.26	210.31	4760695.0
2015-11-03 11:00:00	SPY	ETF	210.315	210.48	210.21	210.41	3575943.0
2015-11-03 11:30:00	SPY	ETF	210.41	210.94	210.36	210.88	7453706.0
2015-11-03 12:00:00	SPY	ETF	210.885	210.94	210.59	210.69	4207285.0
2015-11-03 12:30:00	SPY	ETF	210.695	210.89	210.56	210.8263	3152162.0
2015-11-03 13:00:00	SPY	ETF	210.825	211.025	210.77	210.98	4439738.0
2015-11-03 13:30:00	SPY	ETF	210.975	211.23	210.91	211.1006	6110356.0
2015-11-03 14:00:00	SPY	ETF	211.105	211.6	211.08	211.58	13350435.0
2015-11-03 14:30:00	SPY	ETF	211.58	211.66	211.35	211.415	10218312.0
2015-11-03 15:00:00	SPY	ETF	211.415	211.43	211.18	211.21	5029925.0
2015-11-03 15:30:00	SPY	ETF	211.21	211.26	210.74	210.96	10232027.0
2015-11-03 16:00:00	SPY	ETF	210.95	211.0	210.78	210.9	3786745.0
2015-11-03 16:30:00	SPY	ETF	210.9	210.93	210.82	210.9	362438.0
2015-11-03 17:00:00	SPY	ETF	210.9	210.9	210.83	210.89	38795.0
2015-11-03 17:30:00	SPY	ETF	210.91	210.93	210.82	210.82	27370.0
2015-11-03 18:00:00	SPY	ETF	210.86	210.87	210.8	210.84	34697.0
2015-11-03 18:30:00	SPY	ETF	210.84	210.85	210.82	210.83	6070.0
2015-11-03 19:00:00	SPY	ETF	210.83	211.0	210.75	210.77	15201.0
2015-11-03 19:30:00	SPY	ETF	210.76	210.82	210.74	210.78	35552.0
2015-11-03 04:00:00	QQQ	ETF	114.44	114.44	114.35	114.35	1184.0
2015-11-03 04:30:00	QQQ	ETF	114.43	114.43	114.43	114.43	500.0
2015-11-03 05:00:00	QQQ	ETF	114.43	114.43	114.39	114.41	6300.0
2015-11-03 05:30:00	QQQ	ETF	114.41	114.41	114.39	114.39	3494.0
2015-11-03 06:00:00	QQQ	ETF	114.4	114.4	114.31	114.36	12800.0
2015-11-03 06:30:00	QQQ	ETF	114.37	114.38	114.3	114.3	4900.0
2015-11-03 07:00:00	QQQ	ETF	114.32	114.35	114.27	114.27	16289.0
2015-11-03 07:30:00	QQQ	ETF	114.3	114.33	114.3	114.31	2196.0
2015-11-03 08:00:00	QQQ	ETF	114.34	114.34	114.21	114.23	46773.0
2015-11-03 08:30:00	QQQ	ETF	114.25	114.38	114.25	114.3	21438.0
2015-11-03 09:00:00	QQQ	ETF	114.32	114.37	114.28	114.33	25068.0
2015-11-03 09:30:00	QQQ	ETF	114.37	114.534	114.21	114.369	2299948.0
2015-11-03 10:00:00	QQQ	ETF	114.371	114.64	114.36	114.575	1522401.0
2015-11-03 10:30:00	QQQ	ETF	114.57	114.7	114.51	114.53	1003828.0
2015-11-03 11:00:00	QQQ	ETF	114.54	114.73	114.49	114.7	1075220.0
2015-11-03 11:30:00	QQQ	ETF	114.695	114.99	114.68	114.95	1447983.0
2015-11-03 12:00:00	QQQ	ETF	114.95	115.0299	114.87	114.9177	1180140.0
2015-11-03 12:30:00	QQQ	ETF	114.9182	114.99	114.835	114.95	614129.0

> showing 50 of 13,120 rows — these rows as CSV

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