PREVIEW / etf_30min / 2014-01-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-23.parquet
  size:    363 KB
  rows:    12,025

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
2014-01-23 04:00:00	SPY	ETF	184.03	184.03	183.67	183.7	21712.0
2014-01-23 04:30:00	SPY	ETF	183.78	183.9	183.78	183.8	4899.0
2014-01-23 05:00:00	SPY	ETF	183.85	183.88	183.77	183.88	4450.0
2014-01-23 05:30:00	SPY	ETF	183.82	183.88	183.79	183.83	11725.0
2014-01-23 06:00:00	SPY	ETF	183.78	183.78	183.59	183.7	25021.0
2014-01-23 06:30:00	SPY	ETF	183.7	183.7	183.44	183.51	28609.0
2014-01-23 07:00:00	SPY	ETF	183.51	183.66	183.44	183.66	359901.0
2014-01-23 07:30:00	SPY	ETF	183.68	183.75	183.64	183.73	120999.0
2014-01-23 08:00:00	SPY	ETF	183.68	184.73	183.61	183.73	297469.0
2014-01-23 08:30:00	SPY	ETF	183.73	183.76	183.2	183.25	1248465.0
2014-01-23 09:00:00	SPY	ETF	183.25	183.42	183.07	183.37	1021979.0
2014-01-23 09:30:00	SPY	ETF	183.36	183.4	182.73	182.82	17648249.0
2014-01-23 10:00:00	SPY	ETF	182.82	183.05	182.52	182.64	10028815.0
2014-01-23 10:30:00	SPY	ETF	182.65	182.78	182.4	182.5	8277193.0
2014-01-23 11:00:00	SPY	ETF	182.505	182.74	182.27	182.67	9778406.0
2014-01-23 11:30:00	SPY	ETF	182.67	182.74	182.53	182.72	7937113.0
2014-01-23 12:00:00	SPY	ETF	182.7199	182.76	182.31	182.37	8390763.0
2014-01-23 12:30:00	SPY	ETF	182.376	182.61	182.24	182.47	6411658.0
2014-01-23 13:00:00	SPY	ETF	182.47	182.48	182.17	182.21	5640492.0
2014-01-23 13:30:00	SPY	ETF	182.22	182.26	181.82	181.85	6473423.0
2014-01-23 14:00:00	SPY	ETF	181.855	182.28	181.84	182.16	8482915.0
2014-01-23 14:30:00	SPY	ETF	182.17	182.45	182.08	182.405	7179423.0
2014-01-23 15:00:00	SPY	ETF	182.41	182.485	182.26	182.38	5545047.0
2014-01-23 15:30:00	SPY	ETF	182.39	182.78	182.31	182.78	13909129.0
2014-01-23 16:00:00	SPY	ETF	182.78	184.3381	182.5033	182.8	7294168.0
2014-01-23 16:30:00	SPY	ETF	182.79	184.338	182.77	182.91	4217047.0
2014-01-23 17:00:00	SPY	ETF	182.9	182.93	182.78	182.8	661062.0
2014-01-23 17:30:00	SPY	ETF	182.81	182.86	182.8	182.85	108500.0
2014-01-23 18:00:00	SPY	ETF	182.85	182.89	182.77	182.87	78816.0
2014-01-23 18:30:00	SPY	ETF	182.87	182.87	182.791	182.8	8780.0
2014-01-23 19:00:00	SPY	ETF	182.8	182.95	182.8	182.91	41779.0
2014-01-23 19:30:00	SPY	ETF	182.95	182.97	182.84	182.84	65936.0
2014-01-23 04:00:00	QQQ	ETF	88.97	88.97	88.77	88.77	1100.0
2014-01-23 05:30:00	QQQ	ETF	88.84	88.84	88.84	88.84	100.0
2014-01-23 06:00:00	QQQ	ETF	88.75	88.75	88.73	88.73	200.0
2014-01-23 06:30:00	QQQ	ETF	88.75	88.78	88.64	88.69	36820.0
2014-01-23 07:00:00	QQQ	ETF	88.63	88.73	88.63	88.71	23811.0
2014-01-23 07:30:00	QQQ	ETF	88.74	88.76	88.73	88.76	4600.0
2014-01-23 08:00:00	QQQ	ETF	88.77	88.77	88.68	88.691	96397.0
2014-01-23 08:30:00	QQQ	ETF	88.69	88.69	88.389	88.43	296730.0
2014-01-23 09:00:00	QQQ	ETF	88.42	88.52	88.36	88.49	319806.0
2014-01-23 09:30:00	QQQ	ETF	88.5	88.52	88.09	88.2	5509921.0
2014-01-23 10:00:00	QQQ	ETF	88.2001	88.29	87.93	88.03	3107169.0
2014-01-23 10:30:00	QQQ	ETF	88.035	88.14	87.929	88.0	2035675.0
2014-01-23 11:00:00	QQQ	ETF	88.01	88.18	87.89	88.13	2344017.0
2014-01-23 11:30:00	QQQ	ETF	88.131	88.239	88.07	88.22	1198044.0
2014-01-23 12:00:00	QQQ	ETF	88.225	88.25	88.01	88.089	1257991.0
2014-01-23 12:30:00	QQQ	ETF	88.09	88.1651	87.98	88.1593	1155801.0
2014-01-23 13:00:00	QQQ	ETF	88.159	88.159	88.0	88.06	895810.0
2014-01-23 13:30:00	QQQ	ETF	88.06	88.115	87.87	87.88	2126304.0

> showing 50 of 12,025 rows — these rows as CSV

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