PREVIEW / etf_30min / 2011-03-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-21.parquet
  size:    283 KB
  rows:    9,435

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
2011-03-21 04:00:00	SPY	ETF	128.26	129.32	128.26	129.32	18987.0
2011-03-21 04:30:00	SPY	ETF	129.32	129.51	129.28	129.45	5376.0
2011-03-21 05:00:00	SPY	ETF	129.36	129.36	129.25	129.32	7700.0
2011-03-21 05:30:00	SPY	ETF	129.27	129.36	129.27	129.32	2400.0
2011-03-21 06:00:00	SPY	ETF	129.23	129.45	129.19	129.34	18500.0
2011-03-21 06:30:00	SPY	ETF	129.35	129.42	129.29	129.39	52550.0
2011-03-21 07:00:00	SPY	ETF	129.37	129.41	129.15	129.27	1153115.0
2011-03-21 07:30:00	SPY	ETF	129.29	129.42	129.26	129.31	266490.0
2011-03-21 08:00:00	SPY	ETF	129.33	129.49	129.24	129.42	3846581.0
2011-03-21 08:30:00	SPY	ETF	129.42	129.46	129.25	129.33	1367946.0
2011-03-21 09:00:00	SPY	ETF	129.33	129.39	129.23	129.35	1907244.0
2011-03-21 09:30:00	SPY	ETF	129.35	129.88	129.2	129.74	27723674.0
2011-03-21 10:00:00	SPY	ETF	129.75	130.01	129.64	129.93	14283157.0
2011-03-21 10:30:00	SPY	ETF	129.93	129.95	129.66	129.76	9703796.0
2011-03-21 11:00:00	SPY	ETF	129.76	130.0	129.5	129.8101	9758713.0
2011-03-21 11:30:00	SPY	ETF	129.81	129.87	129.68	129.75	6379187.0
2011-03-21 12:00:00	SPY	ETF	129.76	129.91	129.73	129.9	6295066.0
2011-03-21 12:30:00	SPY	ETF	129.905	129.94	129.71	129.76	6886162.0
2011-03-21 13:00:00	SPY	ETF	129.755	129.77	129.55	129.63	5192917.0
2011-03-21 13:30:00	SPY	ETF	129.63	129.82	129.53	129.8	6509630.0
2011-03-21 14:00:00	SPY	ETF	129.8	129.85	129.72	129.78	3717981.0
2011-03-21 14:30:00	SPY	ETF	129.77	129.91	129.64	129.65	6677928.0
2011-03-21 15:00:00	SPY	ETF	129.65	129.76	129.43	129.515	9245505.0
2011-03-21 15:30:00	SPY	ETF	129.52	129.79	129.51	129.725	18036388.0
2011-03-21 16:00:00	SPY	ETF	129.72	129.86	127.8328	129.69	10683455.0
2011-03-21 16:30:00	SPY	ETF	129.68	129.71	129.58	129.62	544839.0
2011-03-21 17:00:00	SPY	ETF	129.66	129.68	129.58	129.68	38201.0
2011-03-21 17:30:00	SPY	ETF	129.67	129.7	129.64	129.68	8720.0
2011-03-21 18:00:00	SPY	ETF	129.67	129.8	129.65	129.75	170589.0
2011-03-21 18:30:00	SPY	ETF	129.78	129.78	129.69	129.75	14697.0
2011-03-21 19:00:00	SPY	ETF	129.74	129.77	129.7	129.76	45117.0
2011-03-21 19:30:00	SPY	ETF	129.75	129.78	129.65	129.71	51086.0
2011-03-21 04:00:00	QQQ	ETF	55.09	55.17	55.06	55.17	6975.0
2011-03-21 04:30:00	QQQ	ETF	55.17	55.27	55.17	55.27	11305.0
2011-03-21 05:00:00	QQQ	ETF	55.21	55.22	55.19	55.19	2100.0
2011-03-21 05:30:00	QQQ	ETF	55.19	55.21	55.19	55.21	600.0
2011-03-21 06:00:00	QQQ	ETF	55.18	55.27	55.17	55.27	2000.0
2011-03-21 06:30:00	QQQ	ETF	55.23	55.26	55.22	55.22	26500.0
2011-03-21 07:00:00	QQQ	ETF	55.22	55.22	55.15	55.2	71643.0
2011-03-21 07:30:00	QQQ	ETF	55.21	55.27	55.21	55.22	174739.0
2011-03-21 08:00:00	QQQ	ETF	55.24	55.28	54.75	55.26	590061.0
2011-03-21 08:30:00	QQQ	ETF	55.25	55.25	55.18	55.2	541242.0
2011-03-21 09:00:00	QQQ	ETF	55.21	55.28	55.19	55.28	622002.0
2011-03-21 09:30:00	QQQ	ETF	55.29	55.63	55.18	55.56	11917189.0
2011-03-21 10:00:00	QQQ	ETF	55.55	55.67	55.51	55.65	5415708.0
2011-03-21 10:30:00	QQQ	ETF	55.65	55.69	55.59	55.63	4503077.0
2011-03-21 11:00:00	QQQ	ETF	55.6281	55.78	55.61	55.68	3365061.0
2011-03-21 11:30:00	QQQ	ETF	55.68	55.7	55.57	55.58	2321246.0
2011-03-21 12:00:00	QQQ	ETF	55.58	55.65	55.57	55.65	2363399.0
2011-03-21 12:30:00	QQQ	ETF	55.6491	55.66	55.54	55.58	2234212.0

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

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