PREVIEW / etf_30min / 2014-06-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-24.parquet
  size:    346 KB
  rows:    11,677

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-06-24 04:00:00	SPY	ETF	195.68	195.7	195.57	195.65	2090.0
2014-06-24 04:30:00	SPY	ETF	195.65	195.66	195.51	195.51	907.0
2014-06-24 05:00:00	SPY	ETF	195.42	195.42	195.25	195.25	3533.0
2014-06-24 05:30:00	SPY	ETF	195.48	195.48	195.23	195.23	19215.0
2014-06-24 06:00:00	SPY	ETF	195.28	195.4	195.28	195.36	9497.0
2014-06-24 06:30:00	SPY	ETF	195.37	195.5	195.34	195.5	25268.0
2014-06-24 07:00:00	SPY	ETF	195.48	195.52	195.41	195.46	49111.0
2014-06-24 07:30:00	SPY	ETF	195.46	195.51	195.38	195.44	76463.0
2014-06-24 08:00:00	SPY	ETF	195.46	195.64	195.43	195.57	110087.0
2014-06-24 08:30:00	SPY	ETF	195.56	195.63	195.55	195.59	225520.0
2014-06-24 09:00:00	SPY	ETF	195.58	195.59	195.5	195.53	344663.0
2014-06-24 09:30:00	SPY	ETF	195.53	195.87	195.52	195.64	6776657.0
2014-06-24 10:00:00	SPY	ETF	195.659	196.2799	195.65	196.2628	7318601.0
2014-06-24 10:30:00	SPY	ETF	196.27	196.44	196.26	196.39	4979269.0
2014-06-24 11:00:00	SPY	ETF	196.39	196.5	196.35	196.37	5137522.0
2014-06-24 11:30:00	SPY	ETF	196.37	196.4	196.295	196.3599	3277884.0
2014-06-24 12:00:00	SPY	ETF	196.355	196.37	196.25	196.325	2511350.0
2014-06-24 12:30:00	SPY	ETF	196.32	196.325	196.11	196.1444	4097354.0
2014-06-24 13:00:00	SPY	ETF	196.14	196.14	195.61	195.8	9282156.0
2014-06-24 13:30:00	SPY	ETF	195.815	195.89	195.56	195.6	4599019.0
2014-06-24 14:00:00	SPY	ETF	195.59	195.79	195.37	195.43	5691420.0
2014-06-24 14:30:00	SPY	ETF	195.43	195.49	195.27	195.36	5197993.0
2014-06-24 15:00:00	SPY	ETF	195.36	195.36	194.56	194.68	14401379.0
2014-06-24 15:30:00	SPY	ETF	194.67	194.9	194.48	194.7	15492422.0
2014-06-24 16:00:00	SPY	ETF	194.71	195.88	194.6696	194.82	3922290.0
2014-06-24 16:30:00	SPY	ETF	194.82	194.86	194.74	194.74	681960.0
2014-06-24 17:00:00	SPY	ETF	194.74	194.81	194.69	194.76	163955.0
2014-06-24 17:30:00	SPY	ETF	194.76	194.83	194.71	194.73	214000.0
2014-06-24 18:00:00	SPY	ETF	194.75	194.75	194.62	194.63	62543.0
2014-06-24 18:30:00	SPY	ETF	194.64	194.73	194.64	194.67	41770.0
2014-06-24 19:00:00	SPY	ETF	194.67	194.7	194.63	194.63	42542.0
2014-06-24 19:30:00	SPY	ETF	194.63	194.72	194.63	194.7	14313.0
2014-06-24 04:00:00	QQQ	ETF	92.74	92.74	92.7	92.7	300.0
2014-06-24 04:30:00	QQQ	ETF	92.68	92.68	92.64	92.64	300.0
2014-06-24 05:00:00	QQQ	ETF	92.62	92.62	92.5	92.6	2700.0
2014-06-24 05:30:00	QQQ	ETF	92.54	92.54	92.54	92.54	300.0
2014-06-24 06:00:00	QQQ	ETF	92.6	92.6	92.57	92.59	5000.0
2014-06-24 07:00:00	QQQ	ETF	92.6	92.6	92.6	92.6	200.0
2014-06-24 07:30:00	QQQ	ETF	92.68	92.73	92.68	92.73	2200.0
2014-06-24 08:00:00	QQQ	ETF	92.65	92.79	92.65	92.75	21904.0
2014-06-24 08:30:00	QQQ	ETF	92.74	92.79	92.74	92.78	4700.0
2014-06-24 09:00:00	QQQ	ETF	92.77	92.81	92.76	92.78	260042.0
2014-06-24 09:30:00	QQQ	ETF	92.79	93.11	92.77	93.02	3078515.0
2014-06-24 10:00:00	QQQ	ETF	93.0	93.405	93.0	93.4	2904046.0
2014-06-24 10:30:00	QQQ	ETF	93.41	93.54	93.41	93.5099	2176324.0
2014-06-24 11:00:00	QQQ	ETF	93.51	93.57	93.49	93.53	1404341.0
2014-06-24 11:30:00	QQQ	ETF	93.53	93.56	93.485	93.53	951900.0
2014-06-24 12:00:00	QQQ	ETF	93.53	93.55	93.48	93.53	795019.0
2014-06-24 12:30:00	QQQ	ETF	93.52	93.56	93.43	93.48	941696.0
2014-06-24 13:00:00	QQQ	ETF	93.47	93.485	93.17	93.305	3226317.0

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

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