PREVIEW / etf_30min / 2013-10-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-01.parquet
  size:    325 KB
  rows:    10,897

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
2013-10-01 04:00:00	SPY	ETF	168.65	168.84	168.65	168.7	10400.0
2013-10-01 04:30:00	SPY	ETF	168.68	168.72	168.68	168.72	16700.0
2013-10-01 05:00:00	SPY	ETF	168.74	168.76	168.44	168.62	17660.0
2013-10-01 05:30:00	SPY	ETF	168.64	168.72	168.6	168.6	14682.0
2013-10-01 06:00:00	SPY	ETF	168.6	168.72	168.6	168.65	8558.0
2013-10-01 06:30:00	SPY	ETF	168.68	168.72	168.62	168.62	64830.0
2013-10-01 07:00:00	SPY	ETF	168.61	168.62	168.31	168.34	106858.0
2013-10-01 07:30:00	SPY	ETF	168.35	168.42	168.26	168.4	217123.0
2013-10-01 08:00:00	SPY	ETF	168.39	168.58	168.09	168.4	454966.0
2013-10-01 08:30:00	SPY	ETF	168.41	168.51	168.17	168.36	374019.0
2013-10-01 09:00:00	SPY	ETF	168.37	168.38	168.08	168.15	978246.0
2013-10-01 09:30:00	SPY	ETF	168.14	168.7	168.0	168.28	19043595.0
2013-10-01 10:00:00	SPY	ETF	168.28	168.96	168.23	168.81	12249255.0
2013-10-01 10:30:00	SPY	ETF	168.81	169.275	168.81	169.16	9838762.0
2013-10-01 11:00:00	SPY	ETF	169.17	169.22	169.04	169.08	6892525.0
2013-10-01 11:30:00	SPY	ETF	169.08	169.4	169.07	169.29	6965829.0
2013-10-01 12:00:00	SPY	ETF	169.28	169.5	169.19	169.4	5194414.0
2013-10-01 12:30:00	SPY	ETF	169.4	169.41	169.18	169.23	3172183.0
2013-10-01 13:00:00	SPY	ETF	169.22	169.35	169.18	169.2201	3315852.0
2013-10-01 13:30:00	SPY	ETF	169.225	169.27	169.08	169.171	3729519.0
2013-10-01 14:00:00	SPY	ETF	169.1776	169.18	168.77	168.81	6661378.0
2013-10-01 14:30:00	SPY	ETF	168.81	169.0318	168.77	168.9595	6290148.0
2013-10-01 15:00:00	SPY	ETF	168.956	168.96	168.7	168.82	6731130.0
2013-10-01 15:30:00	SPY	ETF	168.81	169.38	168.8	169.33	17681425.0
2013-10-01 16:00:00	SPY	ETF	169.3	169.69	167.9671	169.42	9211032.0
2013-10-01 16:30:00	SPY	ETF	169.43	169.58	167.9671	169.56	2011401.0
2013-10-01 17:00:00	SPY	ETF	169.57	169.68	169.57	169.68	141354.0
2013-10-01 17:30:00	SPY	ETF	169.66	169.66	167.9671	169.62	1610638.0
2013-10-01 18:00:00	SPY	ETF	169.6	169.62	169.53	169.59	78855.0
2013-10-01 18:30:00	SPY	ETF	169.59	169.63	169.56	169.57	18880.0
2013-10-01 19:00:00	SPY	ETF	169.55	169.55	169.42	169.45	44435.0
2013-10-01 19:30:00	SPY	ETF	169.44	169.45	169.38	169.4	32283.0
2013-10-01 04:00:00	QQQ	ETF	79.13	79.21	79.12	79.12	24460.0
2013-10-01 04:30:00	QQQ	ETF	79.12	79.13	79.11	79.13	3700.0
2013-10-01 05:00:00	QQQ	ETF	79.14	79.15	78.98	79.06	30400.0
2013-10-01 05:30:00	QQQ	ETF	79.07	79.11	79.07	79.09	9400.0
2013-10-01 06:00:00	QQQ	ETF	79.08	79.11	79.06	79.09	10600.0
2013-10-01 06:30:00	QQQ	ETF	79.08	79.1	79.06	79.06	7000.0
2013-10-01 07:00:00	QQQ	ETF	79.05	79.06	78.96	78.96	37200.0
2013-10-01 07:30:00	QQQ	ETF	78.95	78.98	78.93	78.98	49500.0
2013-10-01 08:00:00	QQQ	ETF	78.94	79.01	78.87	79.01	50549.0
2013-10-01 08:30:00	QQQ	ETF	79.0	79.05	78.9	79.02	113594.0
2013-10-01 09:00:00	QQQ	ETF	79.02	79.02	78.85	78.88	191385.0
2013-10-01 09:30:00	QQQ	ETF	78.87	79.22	78.8456	78.95	3889734.0
2013-10-01 10:00:00	QQQ	ETF	78.96	79.29	78.93	79.25	3309034.0
2013-10-01 10:30:00	QQQ	ETF	79.26	79.54	79.255	79.49	2449400.0
2013-10-01 11:00:00	QQQ	ETF	79.5	79.52	79.42	79.451	905117.0
2013-10-01 11:30:00	QQQ	ETF	79.45	79.6	79.44	79.56	1276017.0
2013-10-01 12:00:00	QQQ	ETF	79.56	79.72	79.53	79.6769	1254285.0
2013-10-01 12:30:00	QQQ	ETF	79.68	79.68	79.53	79.57	1396296.0

> showing 50 of 10,897 rows — these rows as CSV

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