PREVIEW / etf_30min / 2012-05-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-16.parquet
  size:    298 KB
  rows:    9,976

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-05-16 04:00:00	SPY	ETF	133.25	133.25	133.11	133.15	51540.0
2012-05-16 04:30:00	SPY	ETF	133.3	133.3	133.18	133.2	3519.0
2012-05-16 05:00:00	SPY	ETF	133.27	133.5	133.27	133.5	3650.0
2012-05-16 05:30:00	SPY	ETF	133.3	133.3	133.15	133.23	46320.0
2012-05-16 06:00:00	SPY	ETF	133.19	133.42	133.05	133.33	47394.0
2012-05-16 06:30:00	SPY	ETF	133.52	133.56	133.37	133.39	54150.0
2012-05-16 07:00:00	SPY	ETF	133.4	133.74	133.31	133.67	209763.0
2012-05-16 07:30:00	SPY	ETF	133.65	133.85	133.56	133.85	239975.0
2012-05-16 08:00:00	SPY	ETF	133.81	134.2	133.78	134.155	751034.0
2012-05-16 08:30:00	SPY	ETF	134.18	134.25	133.9	133.94	1454334.0
2012-05-16 09:00:00	SPY	ETF	133.93	134.2	133.92	133.94	2088893.0
2012-05-16 09:30:00	SPY	ETF	133.94	134.47	133.74	134.36	18919390.0
2012-05-16 10:00:00	SPY	ETF	134.35	134.55	134.14	134.31	15277331.0
2012-05-16 10:30:00	SPY	ETF	134.32	134.46	133.97	134.02	12672159.0
2012-05-16 11:00:00	SPY	ETF	134.03	134.3259	133.52	133.62	25584435.0
2012-05-16 11:30:00	SPY	ETF	133.63	133.91	133.47	133.885	12065529.0
2012-05-16 12:00:00	SPY	ETF	133.89	133.9	133.49	133.65	6529030.0
2012-05-16 12:30:00	SPY	ETF	133.65	133.84	133.51	133.56	9836174.0
2012-05-16 13:00:00	SPY	ETF	133.55	133.66	133.41	133.45	7305606.0
2012-05-16 13:30:00	SPY	ETF	133.45	133.4507	133.08	133.42	11407808.0
2012-05-16 14:00:00	SPY	ETF	133.42	133.72	133.0	133.1	17553024.0
2012-05-16 14:30:00	SPY	ETF	133.1	133.52	132.91	133.389	14817491.0
2012-05-16 15:00:00	SPY	ETF	133.38	133.43	132.93	132.958	11360406.0
2012-05-16 15:30:00	SPY	ETF	132.94	133.25	132.8	132.85	25020260.0
2012-05-16 16:00:00	SPY	ETF	132.85	133.5623	132.78	132.87	7056401.0
2012-05-16 16:30:00	SPY	ETF	132.88	132.95	132.76	132.91	2525541.0
2012-05-16 17:00:00	SPY	ETF	132.89	132.94	132.75	132.78	612970.0
2012-05-16 17:30:00	SPY	ETF	132.77	132.81	132.74	132.75	20166.0
2012-05-16 18:00:00	SPY	ETF	132.73	132.82	132.66	132.8	45014.0
2012-05-16 18:30:00	SPY	ETF	132.81	132.93	132.81	132.9	74604.0
2012-05-16 19:00:00	SPY	ETF	132.92	132.94	132.88	132.94	13574.0
2012-05-16 19:30:00	SPY	ETF	132.94	133.15	132.94	133.13	164576.0
2012-05-16 06:30:00	QQQ	ETF	63.41	63.41	63.35	63.4	4458.0
2012-05-16 07:00:00	QQQ	ETF	63.4	63.53	63.36	63.48	17200.0
2012-05-16 07:30:00	QQQ	ETF	63.46	63.58	63.46	63.58	47050.0
2012-05-16 08:00:00	QQQ	ETF	63.56	63.74	63.55	63.73	245130.0
2012-05-16 08:30:00	QQQ	ETF	63.75	63.78	63.56	63.58	248724.0
2012-05-16 09:00:00	QQQ	ETF	63.57	63.71	63.37	63.62	200964.0
2012-05-16 09:30:00	QQQ	ETF	63.61	63.78	63.37	63.69	5766821.0
2012-05-16 10:00:00	QQQ	ETF	63.69	63.76	63.47	63.66	5330149.0
2012-05-16 10:30:00	QQQ	ETF	63.66	63.76	63.5799	63.59	3090312.0
2012-05-16 11:00:00	QQQ	ETF	63.595	63.63	63.26	63.2825	7057442.0
2012-05-16 11:30:00	QQQ	ETF	63.28	63.43	63.21	63.42	3396267.0
2012-05-16 12:00:00	QQQ	ETF	63.42	63.42	63.27	63.3499	1815660.0
2012-05-16 12:30:00	QQQ	ETF	63.34	63.43	63.28	63.295	2000747.0
2012-05-16 13:00:00	QQQ	ETF	63.29	63.36	63.23	63.248	1183061.0
2012-05-16 13:30:00	QQQ	ETF	63.25	63.25	62.86	63.045	4216764.0
2012-05-16 14:00:00	QQQ	ETF	63.05	63.19	62.8599	62.93	4783099.0
2012-05-16 14:30:00	QQQ	ETF	62.93	63.16	62.81	63.1	3153026.0
2012-05-16 15:00:00	QQQ	ETF	63.1	63.12	62.821	62.86	3013508.0

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

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