PREVIEW / etf_30min / 2014-08-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-21.parquet
  size:    332 KB
  rows:    11,460

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-08-21 04:00:00	SPY	ETF	199.17	199.25	199.11	199.19	2663.0
2014-08-21 04:30:00	SPY	ETF	199.2	199.35	199.18	199.26	31385.0
2014-08-21 05:00:00	SPY	ETF	199.22	199.22	199.16	199.16	2865.0
2014-08-21 05:30:00	SPY	ETF	199.05	199.28	199.05	199.28	6500.0
2014-08-21 06:00:00	SPY	ETF	199.29	199.33	199.28	199.32	2399.0
2014-08-21 06:30:00	SPY	ETF	199.29	199.29	199.21	199.23	9250.0
2014-08-21 07:00:00	SPY	ETF	199.26	199.32	199.19	199.19	47702.0
2014-08-21 07:30:00	SPY	ETF	199.2	199.31	199.19	199.28	53669.0
2014-08-21 08:00:00	SPY	ETF	199.28	199.34	199.26	199.26	288166.0
2014-08-21 08:30:00	SPY	ETF	199.27	199.27	199.15	199.22	330317.0
2014-08-21 09:00:00	SPY	ETF	199.24	199.27	199.05	199.09	297544.0
2014-08-21 09:30:00	SPY	ETF	199.09	199.43	198.95	199.34	7869412.0
2014-08-21 10:00:00	SPY	ETF	199.36	199.49	198.93	199.24	9948649.0
2014-08-21 10:30:00	SPY	ETF	199.25	199.53	199.23	199.41	6818679.0
2014-08-21 11:00:00	SPY	ETF	199.42	199.57	199.4	199.4	3436980.0
2014-08-21 11:30:00	SPY	ETF	199.4	199.48	199.3	199.33	3176676.0
2014-08-21 12:00:00	SPY	ETF	199.325	199.48	199.32	199.39	2646912.0
2014-08-21 12:30:00	SPY	ETF	199.39	199.46	199.35	199.41	1365705.0
2014-08-21 13:00:00	SPY	ETF	199.4	199.64	199.4	199.63	3269974.0
2014-08-21 13:30:00	SPY	ETF	199.63	199.64	199.51	199.555	1717056.0
2014-08-21 14:00:00	SPY	ETF	199.555	199.62	199.49	199.581	1776360.0
2014-08-21 14:30:00	SPY	ETF	199.58	199.7	199.57	199.66	3113455.0
2014-08-21 15:00:00	SPY	ETF	199.66	199.76	199.64	199.66	2544900.0
2014-08-21 15:30:00	SPY	ETF	199.66	199.69	199.45	199.49	7740236.0
2014-08-21 16:00:00	SPY	ETF	199.48	199.6919	198.9285	199.5	5519821.0
2014-08-21 16:30:00	SPY	ETF	199.52	199.59	199.52	199.55	1559833.0
2014-08-21 17:00:00	SPY	ETF	199.54	199.58	199.52	199.54	258216.0
2014-08-21 17:30:00	SPY	ETF	199.54	199.57	199.54	199.56	5232.0
2014-08-21 18:00:00	SPY	ETF	199.56	199.58	199.56	199.58	15283.0
2014-08-21 18:30:00	SPY	ETF	199.55	199.55	199.52	199.54	2301.0
2014-08-21 19:00:00	SPY	ETF	199.54	199.56	199.54	199.54	1750.0
2014-08-21 19:30:00	SPY	ETF	199.56	199.6	199.56	199.6	25632.0
2014-08-21 05:30:00	QQQ	ETF	98.84	98.84	98.84	98.84	300.0
2014-08-21 06:00:00	QQQ	ETF	98.85	98.85	98.85	98.85	1250.0
2014-08-21 06:30:00	QQQ	ETF	98.85	98.85	98.84	98.84	1950.0
2014-08-21 07:00:00	QQQ	ETF	98.86	98.86	98.81	98.81	11700.0
2014-08-21 07:30:00	QQQ	ETF	98.84	98.87	98.84	98.85	3770.0
2014-08-21 08:00:00	QQQ	ETF	98.85	98.88	98.84	98.88	25122.0
2014-08-21 08:30:00	QQQ	ETF	98.87	98.87	98.81	98.86	128527.0
2014-08-21 09:00:00	QQQ	ETF	98.85	98.88	98.76	98.77	117808.0
2014-08-21 09:30:00	QQQ	ETF	98.76	98.92	98.711	98.8699	2206904.0
2014-08-21 10:00:00	QQQ	ETF	98.852	98.95	98.6	98.79	2798998.0
2014-08-21 10:30:00	QQQ	ETF	98.79	98.94	98.78	98.8499	1279229.0
2014-08-21 11:00:00	QQQ	ETF	98.845	98.9	98.7901	98.795	828982.0
2014-08-21 11:30:00	QQQ	ETF	98.8	98.84	98.74	98.75	677712.0
2014-08-21 12:00:00	QQQ	ETF	98.75	98.83	98.72	98.79	615927.0
2014-08-21 12:30:00	QQQ	ETF	98.79	98.83	98.76	98.7832	572988.0
2014-08-21 13:00:00	QQQ	ETF	98.79	98.91	98.78	98.89	646705.0
2014-08-21 13:30:00	QQQ	ETF	98.89	98.9	98.79	98.8122	875617.0
2014-08-21 14:00:00	QQQ	ETF	98.81	98.9	98.78	98.8668	850178.0

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

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