PREVIEW / etf_30min / 2011-12-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-22.parquet
  size:    284 KB
  rows:    9,620

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-12-22 04:00:00	SPY	ETF	124.4	124.5	124.33	124.5	25050.0
2011-12-22 04:30:00	SPY	ETF	124.64	124.75	124.64	124.75	121590.0
2011-12-22 05:00:00	SPY	ETF	124.8	124.88	124.56	124.68	46562.0
2011-12-22 05:30:00	SPY	ETF	124.53	124.75	124.5	124.74	38300.0
2011-12-22 06:00:00	SPY	ETF	124.65	124.7	124.56	124.56	17015.0
2011-12-22 06:30:00	SPY	ETF	124.68	124.76	124.67	124.69	18095.0
2011-12-22 07:00:00	SPY	ETF	124.65	124.82	124.59	124.8	61050.0
2011-12-22 07:30:00	SPY	ETF	124.78	124.83	124.66	124.72	320504.0
2011-12-22 08:00:00	SPY	ETF	124.74	124.89	124.65	124.81	771213.0
2011-12-22 08:30:00	SPY	ETF	124.81	125.0	124.39	124.57	1380093.0
2011-12-22 09:00:00	SPY	ETF	124.57	124.69	124.51	124.64	860528.0
2011-12-22 09:30:00	SPY	ETF	124.63	125.069	124.36	124.96	14506049.0
2011-12-22 10:00:00	SPY	ETF	124.96	125.12	124.72	124.99	10114158.0
2011-12-22 10:30:00	SPY	ETF	124.98	125.01	124.59	124.81	7778057.0
2011-12-22 11:00:00	SPY	ETF	124.8	124.979	124.68	124.77	9318969.0
2011-12-22 11:30:00	SPY	ETF	124.78	124.92	124.66	124.88	8245588.0
2011-12-22 12:00:00	SPY	ETF	124.88	125.26	124.855	125.24	6132291.0
2011-12-22 12:30:00	SPY	ETF	125.25	125.3	125.15	125.21	4184586.0
2011-12-22 13:00:00	SPY	ETF	125.22	125.32	125.13	125.29	5073959.0
2011-12-22 13:30:00	SPY	ETF	125.3	125.39	125.2	125.2	4278951.0
2011-12-22 14:00:00	SPY	ETF	125.2	125.34	125.14	125.32	4168985.0
2011-12-22 14:30:00	SPY	ETF	125.3289	125.36	125.08	125.11	5844353.0
2011-12-22 15:00:00	SPY	ETF	125.1	125.39	125.08	125.35	7157270.0
2011-12-22 15:30:00	SPY	ETF	125.34	125.39	125.09	125.31	19684809.0
2011-12-22 16:00:00	SPY	ETF	125.33	125.54	125.0208	125.37	8059193.0
2011-12-22 16:30:00	SPY	ETF	125.38	125.58	125.248	125.56	286279.0
2011-12-22 17:00:00	SPY	ETF	125.55	125.63	125.43	125.6	161956.0
2011-12-22 17:30:00	SPY	ETF	125.58	125.66	125.54	125.62	153164.0
2011-12-22 18:00:00	SPY	ETF	125.6	125.65	125.53	125.61	74389.0
2011-12-22 18:30:00	SPY	ETF	125.61	125.78	125.6	125.75	159008.0
2011-12-22 19:00:00	SPY	ETF	125.75	125.77	125.66	125.71	123809.0
2011-12-22 19:30:00	SPY	ETF	125.71	125.77	125.67	125.7	55356.0
2011-12-22 04:00:00	QQQ	ETF	55.28	55.28	55.28	55.28	190.0
2011-12-22 05:00:00	QQQ	ETF	55.27	55.27	55.23	55.23	350.0
2011-12-22 05:30:00	QQQ	ETF	55.23	55.23	55.23	55.23	100.0
2011-12-22 06:30:00	QQQ	ETF	55.31	55.32	55.27	55.27	8000.0
2011-12-22 07:00:00	QQQ	ETF	55.27	55.32	55.26	55.32	8000.0
2011-12-22 07:30:00	QQQ	ETF	55.32	55.32	55.26	55.3	27558.0
2011-12-22 08:00:00	QQQ	ETF	55.31	55.36	55.26	55.32	117106.0
2011-12-22 08:30:00	QQQ	ETF	55.33	55.38	55.14	55.21	163978.0
2011-12-22 09:00:00	QQQ	ETF	55.24	55.27	55.2	55.23	344550.0
2011-12-22 09:30:00	QQQ	ETF	55.22	55.53	55.17	55.441	4249662.0
2011-12-22 10:00:00	QQQ	ETF	55.444	55.52	55.3	55.4481	2628249.0
2011-12-22 10:30:00	QQQ	ETF	55.44	55.45	55.2601	55.378	2083013.0
2011-12-22 11:00:00	QQQ	ETF	55.37	55.48	55.35	55.44	3387437.0
2011-12-22 11:30:00	QQQ	ETF	55.45	55.52	55.41	55.489	2138528.0
2011-12-22 12:00:00	QQQ	ETF	55.48	55.61	55.46	55.6	1830279.0
2011-12-22 12:30:00	QQQ	ETF	55.6	55.6261	55.55	55.58	1092136.0
2011-12-22 13:00:00	QQQ	ETF	55.5799	55.59	55.53	55.56	849720.0
2011-12-22 13:30:00	QQQ	ETF	55.57	55.6	55.53	55.54	992713.0

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

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