PREVIEW / etf_30min / 2013-10-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-08.parquet
  size:    333 KB
  rows:    10,890

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
2013-10-08 04:00:00	SPY	ETF	167.42	167.47	167.26	167.45	6436.0
2013-10-08 04:30:00	SPY	ETF	167.43	167.54	167.27	167.32	7542.0
2013-10-08 05:00:00	SPY	ETF	167.29	167.29	167.23	167.23	6393.0
2013-10-08 05:30:00	SPY	ETF	167.23	167.28	167.13	167.23	17759.0
2013-10-08 06:00:00	SPY	ETF	167.24	167.29	167.19	167.21	7000.0
2013-10-08 06:30:00	SPY	ETF	167.21	167.39	167.21	167.25	86000.0
2013-10-08 07:00:00	SPY	ETF	167.29	167.34	167.17	167.31	58607.0
2013-10-08 07:30:00	SPY	ETF	167.31	167.39	167.25	167.39	126060.0
2013-10-08 08:00:00	SPY	ETF	167.38	167.64	167.24	167.55	516116.0
2013-10-08 08:30:00	SPY	ETF	167.54	167.58	167.38	167.52	432521.0
2013-10-08 09:00:00	SPY	ETF	167.52	167.55	167.34	167.41	1024290.0
2013-10-08 09:30:00	SPY	ETF	167.4	167.62	167.05	167.54	16400568.0
2013-10-08 10:00:00	SPY	ETF	167.54	167.58	167.16	167.4	9949397.0
2013-10-08 10:30:00	SPY	ETF	167.41	167.425	166.67	166.76	12649386.0
2013-10-08 11:00:00	SPY	ETF	166.758	166.83	166.46	166.69	11262254.0
2013-10-08 11:30:00	SPY	ETF	166.68	166.68	166.06	166.35	14647256.0
2013-10-08 12:00:00	SPY	ETF	166.35	166.37	165.97	166.105	8911406.0
2013-10-08 12:30:00	SPY	ETF	166.1	166.35	165.84	166.27	7454456.0
2013-10-08 13:00:00	SPY	ETF	166.27	166.4	165.94	166.22	6930931.0
2013-10-08 13:30:00	SPY	ETF	166.23	166.33	165.87	165.9201	9218367.0
2013-10-08 14:00:00	SPY	ETF	165.925	166.08	165.6	166.03	12051562.0
2013-10-08 14:30:00	SPY	ETF	166.03	166.12	165.67	165.92	8216038.0
2013-10-08 15:00:00	SPY	ETF	165.92	166.24	165.68	166.1773	12243925.0
2013-10-08 15:30:00	SPY	ETF	166.17	167.5129	165.36	165.48	25747660.0
2013-10-08 16:00:00	SPY	ETF	165.47	167.5129	165.38	165.42	10758725.0
2013-10-08 16:30:00	SPY	ETF	165.42	167.5129	165.16	165.2	3767863.0
2013-10-08 17:00:00	SPY	ETF	165.2	165.24	165.16	165.2	1178664.0
2013-10-08 17:30:00	SPY	ETF	165.17	165.45	165.17	165.41	427869.0
2013-10-08 18:00:00	SPY	ETF	165.41	165.86	165.4	165.79	537468.0
2013-10-08 18:30:00	SPY	ETF	165.76	165.96	165.63	165.93	102000.0
2013-10-08 19:00:00	SPY	ETF	165.92	166.22	165.92	166.13	295210.0
2013-10-08 19:30:00	SPY	ETF	166.12	166.14	165.91	165.95	81751.0
2013-10-08 04:00:00	QQQ	ETF	78.76	78.81	78.69	78.8	19600.0
2013-10-08 04:30:00	QQQ	ETF	78.79	78.82	78.7	78.72	16800.0
2013-10-08 05:00:00	QQQ	ETF	78.71	78.71	78.69	78.69	1500.0
2013-10-08 05:30:00	QQQ	ETF	78.68	78.7	78.63	78.69	21200.0
2013-10-08 06:00:00	QQQ	ETF	78.7	78.72	78.66	78.66	6300.0
2013-10-08 06:30:00	QQQ	ETF	78.68	78.75	78.68	78.7	7060.0
2013-10-08 07:00:00	QQQ	ETF	78.72	78.73	78.65	78.72	14100.0
2013-10-08 07:30:00	QQQ	ETF	78.71	78.75	78.7	78.73	70815.0
2013-10-08 08:00:00	QQQ	ETF	78.7	78.89	78.7	78.84	79098.0
2013-10-08 08:30:00	QQQ	ETF	78.83	78.84	78.76	78.81	93347.0
2013-10-08 09:00:00	QQQ	ETF	78.81	78.82	78.72	78.75	228021.0
2013-10-08 09:30:00	QQQ	ETF	78.74	78.81	78.43	78.63	3423362.0
2013-10-08 10:00:00	QQQ	ETF	78.64	78.65	78.41	78.48	2530416.0
2013-10-08 10:30:00	QQQ	ETF	78.48	78.49	77.87	77.91	4678459.0
2013-10-08 11:00:00	QQQ	ETF	77.91	77.95	77.69	77.85	2990444.0
2013-10-08 11:30:00	QQQ	ETF	77.84	77.84	77.46	77.66	3297222.0
2013-10-08 12:00:00	QQQ	ETF	77.66	77.67	77.35	77.455	2931344.0
2013-10-08 12:30:00	QQQ	ETF	77.46	77.589	77.3	77.56	2946372.0

> showing 50 of 10,890 rows — these rows as CSV

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