PREVIEW / etf_30min / 2012-10-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-25.parquet
  size:    286 KB
  rows:    9,687

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-10-25 04:00:00	SPY	ETF	141.76	142.03	141.76	141.99	3412.0
2012-10-25 04:30:00	SPY	ETF	141.93	141.93	141.93	141.93	200.0
2012-10-25 05:00:00	SPY	ETF	141.97	141.99	141.91	141.99	2200.0
2012-10-25 05:30:00	SPY	ETF	141.99	142.06	141.86	141.86	57800.0
2012-10-25 06:00:00	SPY	ETF	141.87	141.94	141.77	141.77	15350.0
2012-10-25 06:30:00	SPY	ETF	141.82	141.91	141.75	141.84	129500.0
2012-10-25 07:00:00	SPY	ETF	141.86	142.02	141.83	141.99	187753.0
2012-10-25 07:30:00	SPY	ETF	141.98	142.02	141.87	141.91	191512.0
2012-10-25 08:00:00	SPY	ETF	141.92	142.1	141.75	141.95	411109.0
2012-10-25 08:30:00	SPY	ETF	142.05	142.24	141.76	141.91	811699.0
2012-10-25 09:00:00	SPY	ETF	141.9	142.11	141.89	142.01	284281.0
2012-10-25 09:30:00	SPY	ETF	142.02	142.28	141.78	141.9	16046368.0
2012-10-25 10:00:00	SPY	ETF	141.89	142.01	141.61	141.7	10746115.0
2012-10-25 10:30:00	SPY	ETF	141.7	141.7	141.18	141.4	9230399.0
2012-10-25 11:00:00	SPY	ETF	141.4	141.54	140.96	141.048	8930394.0
2012-10-25 11:30:00	SPY	ETF	141.05	141.14	140.57	140.895	14474941.0
2012-10-25 12:00:00	SPY	ETF	140.89	140.97	140.74	140.9	5532131.0
2012-10-25 12:30:00	SPY	ETF	140.9	141.29	140.71	141.2701	9860196.0
2012-10-25 13:00:00	SPY	ETF	141.275	141.46	141.135	141.41	5490346.0
2012-10-25 13:30:00	SPY	ETF	141.4	141.44	141.15	141.355	4600695.0
2012-10-25 14:00:00	SPY	ETF	141.355	141.39	141.08	141.26	4964272.0
2012-10-25 14:30:00	SPY	ETF	141.26	141.51	141.22	141.24	5797876.0
2012-10-25 15:00:00	SPY	ETF	141.235	141.3	141.04	141.14	6040421.0
2012-10-25 15:30:00	SPY	ETF	141.14	141.43	141.06	141.42	13593640.0
2012-10-25 16:00:00	SPY	ETF	141.42	141.6	141.05	141.6	7099782.0
2012-10-25 16:30:00	SPY	ETF	141.6	141.68	140.33	140.95	5942606.0
2012-10-25 17:00:00	SPY	ETF	141.26	141.38	140.89	141.16	944678.0
2012-10-25 17:30:00	SPY	ETF	141.14	141.2	141.05	141.16	130563.0
2012-10-25 18:00:00	SPY	ETF	141.15	141.33	141.06	141.31	139754.0
2012-10-25 18:30:00	SPY	ETF	141.32	141.33	141.21	141.25	20730.0
2012-10-25 19:00:00	SPY	ETF	141.28	141.28	141.04	141.14	52285.0
2012-10-25 19:30:00	SPY	ETF	141.14	141.31	141.1	141.27	76918.0
2012-10-25 04:00:00	QQQ	ETF	65.5	65.65	65.5	65.65	500.0
2012-10-25 04:30:00	QQQ	ETF	65.61	65.61	65.57	65.57	1100.0
2012-10-25 06:00:00	QQQ	ETF	65.57	65.57	65.54	65.55	500.0
2012-10-25 06:30:00	QQQ	ETF	65.6	65.6	65.56	65.56	200.0
2012-10-25 07:00:00	QQQ	ETF	65.59	65.66	65.59	65.64	17463.0
2012-10-25 07:30:00	QQQ	ETF	65.66	65.68	65.58	65.64	36400.0
2012-10-25 08:00:00	QQQ	ETF	65.64	65.65	65.56	65.58	87300.0
2012-10-25 08:30:00	QQQ	ETF	65.6	65.63	65.53	65.6	214210.0
2012-10-25 09:00:00	QQQ	ETF	65.61	65.72	65.6	65.6	108759.0
2012-10-25 09:30:00	QQQ	ETF	65.61	65.72	65.41	65.46	4782101.0
2012-10-25 10:00:00	QQQ	ETF	65.46	65.65	65.32	65.48	2925263.0
2012-10-25 10:30:00	QQQ	ETF	65.48	65.48	65.21	65.3	1950915.0
2012-10-25 11:00:00	QQQ	ETF	65.29	65.38	65.13	65.182	1549004.0
2012-10-25 11:30:00	QQQ	ETF	65.19	65.21	64.97	65.12	3325967.0
2012-10-25 12:00:00	QQQ	ETF	65.1101	65.19	65.05	65.11	1329333.0
2012-10-25 12:30:00	QQQ	ETF	65.12	65.2	64.97	65.2	1472079.0
2012-10-25 13:00:00	QQQ	ETF	65.2	65.31	65.1	65.28	1331911.0
2012-10-25 13:30:00	QQQ	ETF	65.28	65.301	65.19	65.27	728696.0

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

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