PREVIEW / etf_30min / 2013-08-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-15.parquet
  size:    345 KB
  rows:    11,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
2013-08-15 04:00:00	SPY	ETF	168.28	168.46	168.28	168.46	6485.0
2013-08-15 04:30:00	SPY	ETF	168.46	168.55	168.46	168.48	12500.0
2013-08-15 05:00:00	SPY	ETF	168.46	168.48	168.42	168.46	2400.0
2013-08-15 05:30:00	SPY	ETF	168.48	168.48	168.36	168.36	2500.0
2013-08-15 06:00:00	SPY	ETF	168.38	168.4	168.05	168.1	54050.0
2013-08-15 06:30:00	SPY	ETF	168.1	168.13	167.84	167.98	131840.0
2013-08-15 07:00:00	SPY	ETF	168.0	168.07	167.94	167.97	262045.0
2013-08-15 07:30:00	SPY	ETF	167.95	167.95	167.67	167.76	541819.0
2013-08-15 08:00:00	SPY	ETF	168.01	168.01	167.6	167.7	701572.0
2013-08-15 08:30:00	SPY	ETF	167.72	167.72	167.14	167.44	2051348.0
2013-08-15 09:00:00	SPY	ETF	167.44	167.45	167.18	167.42	1076417.0
2013-08-15 09:30:00	SPY	ETF	167.41	167.43	166.55	166.62	21637748.0
2013-08-15 10:00:00	SPY	ETF	166.62	166.77	166.17	166.62	20929158.0
2013-08-15 10:30:00	SPY	ETF	166.62	166.7	166.23	166.4	9028056.0
2013-08-15 11:00:00	SPY	ETF	166.4	166.89	166.38	166.83	10265456.0
2013-08-15 11:30:00	SPY	ETF	166.83	166.99	166.74	166.75	5891221.0
2013-08-15 12:00:00	SPY	ETF	166.75	166.99	166.67	166.8899	4356089.0
2013-08-15 12:30:00	SPY	ETF	166.88	167.04	166.65	166.67	4275473.0
2013-08-15 13:00:00	SPY	ETF	166.67	166.75	166.27	166.36	7000495.0
2013-08-15 13:30:00	SPY	ETF	166.36	166.65	166.345	166.48	4312178.0
2013-08-15 14:00:00	SPY	ETF	166.47	166.64	166.09	166.5376	9250306.0
2013-08-15 14:30:00	SPY	ETF	166.53	166.74	166.43	166.52	5466130.0
2013-08-15 15:00:00	SPY	ETF	166.52	166.56	166.185	166.32	9690883.0
2013-08-15 15:30:00	SPY	ETF	166.32	166.6	166.29	166.35	16205323.0
2013-08-15 16:00:00	SPY	ETF	166.34	166.83	166.07	166.12	5395503.0
2013-08-15 16:30:00	SPY	ETF	166.13	166.391	166.07	166.07	1956897.0
2013-08-15 17:00:00	SPY	ETF	166.07	166.11	165.96	166.01	2687772.0
2013-08-15 17:30:00	SPY	ETF	166.02	166.03	166.0	166.0	582277.0
2013-08-15 18:00:00	SPY	ETF	166.0	166.22	166.0	166.22	191871.0
2013-08-15 18:30:00	SPY	ETF	166.2	166.34	166.2	166.32	24155.0
2013-08-15 19:00:00	SPY	ETF	166.34	166.34	166.29	166.29	60190.0
2013-08-15 19:30:00	SPY	ETF	166.29	166.31	166.25	166.25	46684.0
2013-08-15 04:00:00	QQQ	ETF	76.34	76.39	76.33	76.39	8800.0
2013-08-15 04:30:00	QQQ	ETF	76.41	76.43	76.41	76.41	2400.0
2013-08-15 05:00:00	QQQ	ETF	76.39	76.39	76.39	76.39	1100.0
2013-08-15 05:30:00	QQQ	ETF	76.41	76.41	76.39	76.39	4600.0
2013-08-15 06:00:00	QQQ	ETF	76.37	76.37	76.27	76.28	20400.0
2013-08-15 06:30:00	QQQ	ETF	76.29	76.29	76.19	76.25	26500.0
2013-08-15 07:00:00	QQQ	ETF	76.27	76.29	76.23	76.24	48420.0
2013-08-15 07:30:00	QQQ	ETF	76.23	76.23	76.13	76.16	143613.0
2013-08-15 08:00:00	QQQ	ETF	76.15	76.3	76.09	76.1	197104.0
2013-08-15 08:30:00	QQQ	ETF	76.1	76.11	75.9	75.95	697770.0
2013-08-15 09:00:00	QQQ	ETF	75.94	76.0	75.89	75.97	230938.0
2013-08-15 09:30:00	QQQ	ETF	75.98	75.99	75.53	75.6	6947973.0
2013-08-15 10:00:00	QQQ	ETF	75.6	75.66	75.29	75.6	5901807.0
2013-08-15 10:30:00	QQQ	ETF	75.61	75.65	75.41	75.512	3434008.0
2013-08-15 11:00:00	QQQ	ETF	75.52	75.759	75.49	75.73	2004618.0
2013-08-15 11:30:00	QQQ	ETF	75.73	75.86	75.71	75.805	1210305.0
2013-08-15 12:00:00	QQQ	ETF	75.8	75.89	75.73	75.8404	860172.0
2013-08-15 12:30:00	QQQ	ETF	75.85	75.9099	75.69	75.7	830539.0

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

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