PREVIEW / etf_30min / 2012-08-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-16.parquet
  size:    284 KB
  rows:    9,485

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-08-16 04:00:00	SPY	ETF	141.03	141.03	141.03	141.03	1000.0
2012-08-16 04:30:00	SPY	ETF	141.06	141.1	141.06	141.1	900.0
2012-08-16 05:00:00	SPY	ETF	141.06	141.12	141.06	141.12	1500.0
2012-08-16 05:30:00	SPY	ETF	141.09	141.09	141.09	141.09	700.0
2012-08-16 06:00:00	SPY	ETF	141.09	141.09	141.07	141.07	614.0
2012-08-16 06:30:00	SPY	ETF	141.05	141.12	141.05	141.12	1800.0
2012-08-16 07:00:00	SPY	ETF	141.12	141.25	141.12	141.17	45309.0
2012-08-16 07:30:00	SPY	ETF	141.21	141.26	141.14	141.17	58819.0
2012-08-16 08:00:00	SPY	ETF	141.18	141.33	141.05	141.29	217537.0
2012-08-16 08:30:00	SPY	ETF	141.22	141.4	141.16	141.2	697794.0
2012-08-16 09:00:00	SPY	ETF	141.21	141.25	141.14	141.15	309455.0
2012-08-16 09:30:00	SPY	ETF	141.15	141.29	140.91	140.97	9849563.0
2012-08-16 10:00:00	SPY	ETF	140.975	141.1	140.8	141.07	8187929.0
2012-08-16 10:30:00	SPY	ETF	141.07	141.42	141.07	141.345	9630108.0
2012-08-16 11:00:00	SPY	ETF	141.345	141.48	141.29	141.45	5399926.0
2012-08-16 11:30:00	SPY	ETF	141.45	141.77	141.41	141.7	7415228.0
2012-08-16 12:00:00	SPY	ETF	141.7	141.78	141.64	141.71	4290511.0
2012-08-16 12:30:00	SPY	ETF	141.71	141.82	141.635	141.79	4555439.0
2012-08-16 13:00:00	SPY	ETF	141.781	141.91	141.76	141.83	3411710.0
2012-08-16 13:30:00	SPY	ETF	141.83	141.88	141.74	141.81	3321515.0
2012-08-16 14:00:00	SPY	ETF	141.82	141.96	141.79	141.91	7070444.0
2012-08-16 14:30:00	SPY	ETF	141.91	142.16	141.91	142.01	8162014.0
2012-08-16 15:00:00	SPY	ETF	142.02	142.16	141.91	142.12	7011904.0
2012-08-16 15:30:00	SPY	ETF	142.12	142.13	141.83	141.99	14518623.0
2012-08-16 16:00:00	SPY	ETF	141.98	142.01	141.0	141.97	12450078.0
2012-08-16 16:30:00	SPY	ETF	141.97	142.11	141.96	142.05	1357022.0
2012-08-16 17:00:00	SPY	ETF	142.03	142.05	141.98	141.98	1010240.0
2012-08-16 17:30:00	SPY	ETF	141.98	142.01	141.92	141.99	49587.0
2012-08-16 18:00:00	SPY	ETF	141.99	141.99	141.95	141.96	7200.0
2012-08-16 18:30:00	SPY	ETF	141.96	141.99	141.95	141.96	3850.0
2012-08-16 19:00:00	SPY	ETF	141.97	142.01	141.97	141.99	9695.0
2012-08-16 19:30:00	SPY	ETF	141.99	142.01	141.96	142.0	15818.0
2012-08-16 06:00:00	QQQ	ETF	67.35	67.35	67.35	67.35	100.0
2012-08-16 07:00:00	QQQ	ETF	67.41	67.42	67.4	67.4	4900.0
2012-08-16 07:30:00	QQQ	ETF	67.41	67.44	67.4	67.44	10000.0
2012-08-16 08:00:00	QQQ	ETF	67.46	67.53	67.45	67.52	344975.0
2012-08-16 08:30:00	QQQ	ETF	67.53	67.57	67.44	67.46	207858.0
2012-08-16 09:00:00	QQQ	ETF	67.45	67.52	67.23	67.49	367057.0
2012-08-16 09:30:00	QQQ	ETF	67.47	67.55	67.415	67.48	2950709.0
2012-08-16 10:00:00	QQQ	ETF	67.48	67.52	67.39	67.51	1900296.0
2012-08-16 10:30:00	QQQ	ETF	67.52	67.75	67.52	67.7	2619853.0
2012-08-16 11:00:00	QQQ	ETF	67.699	67.78	67.67	67.76	1145569.0
2012-08-16 11:30:00	QQQ	ETF	67.76	67.9399	67.7399	67.9	2161754.0
2012-08-16 12:00:00	QQQ	ETF	67.9	67.94	67.87	67.89	1086065.0
2012-08-16 12:30:00	QQQ	ETF	67.89	67.959	67.85	67.949	720962.0
2012-08-16 13:00:00	QQQ	ETF	67.9401	67.99	67.92	67.96	1046894.0
2012-08-16 13:30:00	QQQ	ETF	67.96	67.97	67.87	67.94	1065429.0
2012-08-16 14:00:00	QQQ	ETF	67.93	68.06	67.91	68.0599	3169100.0
2012-08-16 14:30:00	QQQ	ETF	68.06	68.16	68.06	68.13	2455283.0
2012-08-16 15:00:00	QQQ	ETF	68.122	68.17	68.08	68.155	1508880.0

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

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