PREVIEW / etf_30min / 2010-07-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-12.parquet
  size:    242 KB
  rows:    8,109

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
2010-07-12 04:00:00	SPY	ETF	107.33	107.37	107.27	107.27	3950.0
2010-07-12 04:30:00	SPY	ETF	107.3	107.3	107.15	107.21	6100.0
2010-07-12 05:00:00	SPY	ETF	107.18	107.22	107.14	107.21	14100.0
2010-07-12 05:30:00	SPY	ETF	107.19	107.28	107.17	107.26	6000.0
2010-07-12 06:00:00	SPY	ETF	107.29	107.29	107.2	107.24	9900.0
2010-07-12 06:30:00	SPY	ETF	107.31	107.35	107.29	107.3	39299.0
2010-07-12 07:00:00	SPY	ETF	107.3	107.47	107.26	107.38	33831.0
2010-07-12 07:30:00	SPY	ETF	107.38	107.48	107.35	107.42	79414.0
2010-07-12 08:00:00	SPY	ETF	107.42	107.62	107.13	107.52	315107.0
2010-07-12 08:30:00	SPY	ETF	107.52	107.58	107.47	107.57	298509.0
2010-07-12 09:00:00	SPY	ETF	107.57	107.66	107.54	107.62	681638.0
2010-07-12 09:30:00	SPY	ETF	107.6	108.24	107.47	108.12	21837491.0
2010-07-12 10:00:00	SPY	ETF	108.12	108.18	107.73	107.74	11304623.0
2010-07-12 10:30:00	SPY	ETF	107.75	107.88	107.49	107.64	9617090.0
2010-07-12 11:00:00	SPY	ETF	107.63	107.63	107.15	107.46	11618116.0
2010-07-12 11:30:00	SPY	ETF	107.46	107.56	107.395	107.48	5019496.0
2010-07-12 12:00:00	SPY	ETF	107.48	107.86	107.475	107.6699	6478910.0
2010-07-12 12:30:00	SPY	ETF	107.66	107.95	107.51	107.6	5889577.0
2010-07-12 13:00:00	SPY	ETF	107.59	107.96	107.52	107.92	6048140.0
2010-07-12 13:30:00	SPY	ETF	107.92	108.07	107.77	108.0295	5910863.0
2010-07-12 14:00:00	SPY	ETF	108.025	108.06	107.71	107.83	4921946.0
2010-07-12 14:30:00	SPY	ETF	107.82	108.01	107.67	107.87	6494771.0
2010-07-12 15:00:00	SPY	ETF	107.87	107.98	107.64	107.93	8463573.0
2010-07-12 15:30:00	SPY	ETF	107.93	108.09	107.81	108.02	15805309.0
2010-07-12 16:00:00	SPY	ETF	108.02	108.25	107.275	108.17	5987978.0
2010-07-12 16:30:00	SPY	ETF	108.12	108.39	108.08	108.39	451838.0
2010-07-12 17:00:00	SPY	ETF	108.4	108.6	108.37	108.42	342634.0
2010-07-12 17:30:00	SPY	ETF	108.39	108.45	108.37	108.44	46837.0
2010-07-12 18:00:00	SPY	ETF	108.4	108.41	108.03	108.37	151061.0
2010-07-12 18:30:00	SPY	ETF	108.36	108.39	108.34	108.39	93949.0
2010-07-12 19:00:00	SPY	ETF	108.41	108.47	108.39	108.46	22059.0
2010-07-12 19:30:00	SPY	ETF	108.46	108.49	108.4	108.49	54736.0
2010-07-12 05:30:00	QQQ	ETF	44.4	44.4	44.4	44.4	200.0
2010-07-12 06:00:00	QQQ	ETF	44.43	44.43	44.39	44.39	400.0
2010-07-12 06:30:00	QQQ	ETF	44.39	44.39	44.39	44.39	100.0
2010-07-12 07:00:00	QQQ	ETF	44.44	44.49	44.42	44.48	27428.0
2010-07-12 07:30:00	QQQ	ETF	44.46	44.49	44.46	44.49	2085.0
2010-07-12 08:00:00	QQQ	ETF	44.47	44.58	44.46	44.55	171604.0
2010-07-12 08:30:00	QQQ	ETF	44.54	44.62	44.52	44.57	83932.0
2010-07-12 09:00:00	QQQ	ETF	44.57	44.62	44.57	44.58	280315.0
2010-07-12 09:30:00	QQQ	ETF	44.58	45.03	44.53	44.97	11443740.0
2010-07-12 10:00:00	QQQ	ETF	44.97	45.0	44.68	44.7	5983398.0
2010-07-12 10:30:00	QQQ	ETF	44.7	44.76	44.59	44.66	4523954.0
2010-07-12 11:00:00	QQQ	ETF	44.66	44.66	44.47	44.54	5184838.0
2010-07-12 11:30:00	QQQ	ETF	44.54	44.58	44.46	44.48	1883865.0
2010-07-12 12:00:00	QQQ	ETF	44.48	44.67	44.47	44.6199	2985306.0
2010-07-12 12:30:00	QQQ	ETF	44.6155	44.72	44.55	44.55	1836515.0
2010-07-12 13:00:00	QQQ	ETF	44.55	44.74	44.525	44.73	3206728.0
2010-07-12 13:30:00	QQQ	ETF	44.73	44.81	44.69	44.78	2643873.0
2010-07-12 14:00:00	QQQ	ETF	44.78	44.81	44.65	44.7	2001785.0

> showing 50 of 8,109 rows — these rows as CSV

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