PREVIEW / etf_30min / 2014-11-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-21.parquet
  size:    378 KB
  rows:    12,739

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-11-21 04:00:00	SPY	ETF	206.25	206.43	205.7	206.34	4511.0
2014-11-21 04:30:00	SPY	ETF	206.28	206.3	206.28	206.3	2400.0
2014-11-21 05:00:00	SPY	ETF	206.3	206.3	206.24	206.25	2200.0
2014-11-21 05:30:00	SPY	ETF	206.28	207.27	206.28	206.94	133267.0
2014-11-21 06:00:00	SPY	ETF	206.89	207.03	206.77	206.97	46670.0
2014-11-21 06:30:00	SPY	ETF	206.94	207.18	206.94	207.01	72637.0
2014-11-21 07:00:00	SPY	ETF	207.0	207.13	206.89	207.13	170930.0
2014-11-21 07:30:00	SPY	ETF	207.09	207.37	207.09	207.3	961699.0
2014-11-21 08:00:00	SPY	ETF	207.3	207.56	205.91	207.39	2341257.0
2014-11-21 08:30:00	SPY	ETF	207.38	207.44	207.26	207.41	594647.0
2014-11-21 09:00:00	SPY	ETF	207.41	207.67	207.4	207.63	2520751.0
2014-11-21 09:30:00	SPY	ETF	207.64	207.8445	207.26	207.39	25897130.0
2014-11-21 10:00:00	SPY	ETF	207.395	207.43	207.11	207.24	9689099.0
2014-11-21 10:30:00	SPY	ETF	207.25	207.26	206.95	207.04	9017538.0
2014-11-21 11:00:00	SPY	ETF	207.044	207.05	206.79	206.94	11088467.0
2014-11-21 11:30:00	SPY	ETF	206.94	206.99	206.73	206.8101	7011874.0
2014-11-21 12:00:00	SPY	ETF	206.81	206.9	206.48	206.5	5388008.0
2014-11-21 12:30:00	SPY	ETF	206.495	206.7	206.4016	206.49	6256897.0
2014-11-21 13:00:00	SPY	ETF	206.485	206.52	206.08	206.1	5003488.0
2014-11-21 13:30:00	SPY	ETF	206.1	206.56	205.98	206.43	8108200.0
2014-11-21 14:00:00	SPY	ETF	206.44	206.55	206.21	206.25	3566965.0
2014-11-21 14:30:00	SPY	ETF	206.24	206.51	206.1	206.42	4337158.0
2014-11-21 15:00:00	SPY	ETF	206.42	206.64	206.395	206.64	5561680.0
2014-11-21 15:30:00	SPY	ETF	206.65	206.79	206.47	206.68	12434350.0
2014-11-21 16:00:00	SPY	ETF	206.69	206.81	205.98	206.6	7764636.0
2014-11-21 16:30:00	SPY	ETF	206.61	206.73	206.6	206.66	3523314.0
2014-11-21 17:00:00	SPY	ETF	206.66	206.7201	206.65	206.65	2739090.0
2014-11-21 17:30:00	SPY	ETF	206.66	206.81	206.62	206.8	94561.0
2014-11-21 18:00:00	SPY	ETF	206.8	206.87	206.7	206.77	103052.0
2014-11-21 18:30:00	SPY	ETF	206.77	206.79	206.72	206.72	3700.0
2014-11-21 19:00:00	SPY	ETF	206.74	206.76	206.73	206.74	6400.0
2014-11-21 19:30:00	SPY	ETF	206.74	206.78	206.73	206.74	36924.0
2014-11-21 04:00:00	QQQ	ETF	103.82	104.04	103.82	104.04	1300.0
2014-11-21 05:00:00	QQQ	ETF	104.03	104.04	104.03	104.04	200.0
2014-11-21 05:30:00	QQQ	ETF	104.08	104.5	104.08	104.37	23100.0
2014-11-21 06:00:00	QQQ	ETF	104.36	104.39	104.3	104.39	9220.0
2014-11-21 06:30:00	QQQ	ETF	104.47	104.51	104.42	104.42	18880.0
2014-11-21 07:00:00	QQQ	ETF	104.4	104.47	104.38	104.47	47200.0
2014-11-21 07:30:00	QQQ	ETF	104.48	104.53	104.44	104.53	55796.0
2014-11-21 08:00:00	QQQ	ETF	104.49	104.67	104.44	104.55	231179.0
2014-11-21 08:30:00	QQQ	ETF	104.55	104.57	104.5	104.54	123495.0
2014-11-21 09:00:00	QQQ	ETF	104.56	104.66	104.51	104.59	1158508.0
2014-11-21 09:30:00	QQQ	ETF	104.59	104.69	104.31	104.39	4953155.0
2014-11-21 10:00:00	QQQ	ETF	104.38	104.45	104.21	104.41	2712715.0
2014-11-21 10:30:00	QQQ	ETF	104.4161	104.42	104.0	104.14	1523386.0
2014-11-21 11:00:00	QQQ	ETF	104.13	104.205	103.9	104.11	1813236.0
2014-11-21 11:30:00	QQQ	ETF	104.11	104.13	103.95	104.0222	975813.0
2014-11-21 12:00:00	QQQ	ETF	104.029	104.136	103.91	103.93	972220.0
2014-11-21 12:30:00	QQQ	ETF	103.93	104.07	103.89	103.93	1176483.0
2014-11-21 13:00:00	QQQ	ETF	103.92	103.95	103.6549	103.6549	1162607.0

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

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