PREVIEW / etf_30min / 2014-11-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-05.parquet
  size:    364 KB
  rows:    12,358

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-05 04:00:00	SPY	ETF	201.57	201.84	201.57	201.69	34120.0
2014-11-05 04:30:00	SPY	ETF	201.55	201.84	201.52	201.84	44708.0
2014-11-05 05:00:00	SPY	ETF	201.86	201.95	201.84	201.92	30850.0
2014-11-05 05:30:00	SPY	ETF	201.92	201.99	201.9	201.9	52901.0
2014-11-05 06:00:00	SPY	ETF	201.84	201.95	201.71	201.77	20763.0
2014-11-05 06:30:00	SPY	ETF	201.75	201.9	201.75	201.85	21476.0
2014-11-05 07:00:00	SPY	ETF	201.85	202.13	201.85	202.05	132200.0
2014-11-05 07:30:00	SPY	ETF	202.07	202.32	202.07	202.28	455753.0
2014-11-05 08:00:00	SPY	ETF	202.28	202.41	201.9	202.36	658122.0
2014-11-05 08:30:00	SPY	ETF	202.35	202.48	201.07	202.35	605632.0
2014-11-05 09:00:00	SPY	ETF	202.36	202.55	202.3	202.53	1908385.0
2014-11-05 09:30:00	SPY	ETF	202.54	202.59	201.76	201.92	13884159.0
2014-11-05 10:00:00	SPY	ETF	201.92	202.13	201.62	201.73	9417212.0
2014-11-05 10:30:00	SPY	ETF	201.73	201.96	201.45	201.96	6968466.0
2014-11-05 11:00:00	SPY	ETF	201.96	202.21	201.9	202.01	5293907.0
2014-11-05 11:30:00	SPY	ETF	202.0	202.21	201.84	202.175	4660925.0
2014-11-05 12:00:00	SPY	ETF	202.17	202.34	202.05	202.09	5415434.0
2014-11-05 12:30:00	SPY	ETF	202.085	202.31	202.05	202.22	4093738.0
2014-11-05 13:00:00	SPY	ETF	202.224	202.35	202.06	202.13	3756459.0
2014-11-05 13:30:00	SPY	ETF	202.1368	202.21	201.64	201.81	5651602.0
2014-11-05 14:00:00	SPY	ETF	201.81	202.2	201.71	202.12	3616030.0
2014-11-05 14:30:00	SPY	ETF	202.12	202.27	202.03	202.26	3539592.0
2014-11-05 15:00:00	SPY	ETF	202.27	202.32	201.98	202.11	4936389.0
2014-11-05 15:30:00	SPY	ETF	202.1	202.44	202.01	202.37	11029491.0
2014-11-05 16:00:00	SPY	ETF	202.38	202.55	202.04	202.41	3320249.0
2014-11-05 16:30:00	SPY	ETF	202.41	202.5	202.37	202.38	1619190.0
2014-11-05 17:00:00	SPY	ETF	202.38	202.44	202.36	202.41	19355.0
2014-11-05 17:30:00	SPY	ETF	202.41	202.42	202.41	202.42	4245.0
2014-11-05 18:00:00	SPY	ETF	202.41	202.41	202.25	202.32	102627.0
2014-11-05 18:30:00	SPY	ETF	202.31	202.33	202.25	202.3	15540.0
2014-11-05 19:00:00	SPY	ETF	202.3	202.34	202.28	202.32	27725.0
2014-11-05 19:30:00	SPY	ETF	202.29	202.3	202.16	202.16	93685.0
2014-11-05 04:00:00	QQQ	ETF	101.73	101.73	101.7	101.7	2350.0
2014-11-05 04:30:00	QQQ	ETF	101.67	101.78	101.67	101.78	300.0
2014-11-05 05:00:00	QQQ	ETF	101.76	101.83	101.76	101.78	2700.0
2014-11-05 05:30:00	QQQ	ETF	101.81	101.81	101.81	101.81	15000.0
2014-11-05 06:00:00	QQQ	ETF	101.74	101.76	101.73	101.76	2635.0
2014-11-05 06:30:00	QQQ	ETF	101.73	101.75	101.72	101.72	3400.0
2014-11-05 07:00:00	QQQ	ETF	101.74	101.83	101.74	101.81	51963.0
2014-11-05 07:30:00	QQQ	ETF	101.81	101.94	101.81	101.93	39431.0
2014-11-05 08:00:00	QQQ	ETF	101.91	101.96	101.76	101.93	81522.0
2014-11-05 08:30:00	QQQ	ETF	101.94	101.99	101.88	101.96	39829.0
2014-11-05 09:00:00	QQQ	ETF	101.95	102.05	101.9	102.01	337905.0
2014-11-05 09:30:00	QQQ	ETF	102.01	102.03	101.31	101.41	5477665.0
2014-11-05 10:00:00	QQQ	ETF	101.39	101.6	101.22	101.32	2794714.0
2014-11-05 10:30:00	QQQ	ETF	101.32	101.4	101.09	101.39	2084428.0
2014-11-05 11:00:00	QQQ	ETF	101.395	101.58	101.39	101.49	1415434.0
2014-11-05 11:30:00	QQQ	ETF	101.49	101.59	101.33	101.56	1009167.0
2014-11-05 12:00:00	QQQ	ETF	101.559	101.64	101.4434	101.46	1024016.0
2014-11-05 12:30:00	QQQ	ETF	101.46	101.56	101.45	101.5	656143.0

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

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