PREVIEW / etf_30min / 2012-01-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-20.parquet
  size:    282 KB
  rows:    9,495

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
2012-01-20 04:00:00	SPY	ETF	131.18	131.18	131.16	131.16	600.0
2012-01-20 04:30:00	SPY	ETF	131.1	131.1	131.07	131.07	500.0
2012-01-20 05:00:00	SPY	ETF	131.06	131.14	131.01	131.14	400.0
2012-01-20 05:30:00	SPY	ETF	131.31	131.36	131.18	131.18	16700.0
2012-01-20 06:00:00	SPY	ETF	131.18	131.28	131.1	131.2	41600.0
2012-01-20 06:30:00	SPY	ETF	131.1	131.28	131.1	131.14	160090.0
2012-01-20 07:00:00	SPY	ETF	131.11	131.32	131.05	131.3	148861.0
2012-01-20 07:30:00	SPY	ETF	131.31	131.4	131.23	131.24	381647.0
2012-01-20 08:00:00	SPY	ETF	131.25	131.34	131.1	131.15	2064299.0
2012-01-20 08:30:00	SPY	ETF	131.13	131.19	131.03	131.17	2337317.0
2012-01-20 09:00:00	SPY	ETF	131.16	131.28	131.07	131.23	1704338.0
2012-01-20 09:30:00	SPY	ETF	131.24	131.4036	131.09	131.27	19527169.0
2012-01-20 10:00:00	SPY	ETF	131.28	131.32	131.0	131.31	11254709.0
2012-01-20 10:30:00	SPY	ETF	131.3	131.32	131.08	131.11	7494846.0
2012-01-20 11:00:00	SPY	ETF	131.11	131.15	130.96	131.06	6022968.0
2012-01-20 11:30:00	SPY	ETF	131.06	131.08	130.92	131.073	5335908.0
2012-01-20 12:00:00	SPY	ETF	131.075	131.2	131.04	131.148	4478342.0
2012-01-20 12:30:00	SPY	ETF	131.14	131.28	131.14	131.22	4759695.0
2012-01-20 13:00:00	SPY	ETF	131.21	131.39	131.2	131.35	4677754.0
2012-01-20 13:30:00	SPY	ETF	131.35	131.36	131.23	131.23	3496711.0
2012-01-20 14:00:00	SPY	ETF	131.23	131.27	131.11	131.13	4493509.0
2012-01-20 14:30:00	SPY	ETF	131.13	131.18	131.02	131.18	5603039.0
2012-01-20 15:00:00	SPY	ETF	131.18	131.32	131.17	131.3	5831487.0
2012-01-20 15:30:00	SPY	ETF	131.305	131.55	131.2	131.54	19450884.0
2012-01-20 16:00:00	SPY	ETF	131.53	131.61	130.985	131.46	19226578.0
2012-01-20 16:30:00	SPY	ETF	131.46	131.5052	131.4	131.46	3196505.0
2012-01-20 17:00:00	SPY	ETF	131.45	131.68	131.44	131.67	1025772.0
2012-01-20 17:30:00	SPY	ETF	131.69	131.76	131.6	131.74	123856.0
2012-01-20 18:00:00	SPY	ETF	131.74	131.95	131.64	131.67	78155.0
2012-01-20 18:30:00	SPY	ETF	131.68	131.7	131.68	131.68	8680.0
2012-01-20 19:00:00	SPY	ETF	131.7	131.72	131.66	131.72	31768.0
2012-01-20 19:30:00	SPY	ETF	131.72	131.74	131.69	131.71	32090.0
2012-01-20 04:30:00	QQQ	ETF	59.53	59.53	59.53	59.53	130.0
2012-01-20 05:00:00	QQQ	ETF	59.52	59.52	59.52	59.52	130.0
2012-01-20 05:30:00	QQQ	ETF	59.66	59.66	59.65	59.65	1080.0
2012-01-20 06:00:00	QQQ	ETF	59.64	59.64	59.64	59.64	4000.0
2012-01-20 06:30:00	QQQ	ETF	59.61	59.66	59.61	59.62	2300.0
2012-01-20 07:00:00	QQQ	ETF	59.59	59.69	59.58	59.66	94734.0
2012-01-20 07:30:00	QQQ	ETF	59.65	59.72	59.64	59.66	23045.0
2012-01-20 08:00:00	QQQ	ETF	59.65	59.65	59.57	59.59	1021122.0
2012-01-20 08:30:00	QQQ	ETF	59.58	59.58	59.52	59.54	1133611.0
2012-01-20 09:00:00	QQQ	ETF	59.55	59.61	59.52	59.6	750691.0
2012-01-20 09:30:00	QQQ	ETF	59.6	59.7	59.56	59.6299	7222036.0
2012-01-20 10:00:00	QQQ	ETF	59.63	59.77	59.57	59.77	3753005.0
2012-01-20 10:30:00	QQQ	ETF	59.77	59.77	59.65	59.664	3527239.0
2012-01-20 11:00:00	QQQ	ETF	59.67	59.7	59.6	59.65	2447505.0
2012-01-20 11:30:00	QQQ	ETF	59.64	59.68	59.56	59.65	1635346.0
2012-01-20 12:00:00	QQQ	ETF	59.655	59.69	59.64	59.66	804066.0
2012-01-20 12:30:00	QQQ	ETF	59.66	59.71	59.64	59.71	1085496.0
2012-01-20 13:00:00	QQQ	ETF	59.705	59.8	59.7	59.77	2559269.0

> showing 50 of 9,495 rows — these rows as CSV

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