PREVIEW / etf_30min / 2014-09-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-22.parquet
  size:    353 KB
  rows:    12,012

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-09-22 04:00:00	SPY	ETF	199.96	199.96	199.73	199.94	8944.0
2014-09-22 04:30:00	SPY	ETF	199.97	199.97	199.9	199.92	969.0
2014-09-22 05:00:00	SPY	ETF	199.89	199.96	199.85	199.96	707.0
2014-09-22 05:30:00	SPY	ETF	199.89	200.04	199.89	200.04	1325.0
2014-09-22 06:00:00	SPY	ETF	199.98	200.18	199.98	200.16	5513.0
2014-09-22 06:30:00	SPY	ETF	200.09	200.17	200.09	200.15	33300.0
2014-09-22 07:00:00	SPY	ETF	200.17	200.28	200.15	200.17	66459.0
2014-09-22 07:30:00	SPY	ETF	200.16	200.2	200.05	200.17	66755.0
2014-09-22 08:00:00	SPY	ETF	200.6034	200.6034	199.82	200.2	261125.0
2014-09-22 08:30:00	SPY	ETF	200.2	200.25	200.01	200.16	330208.0
2014-09-22 09:00:00	SPY	ETF	200.18	200.34	200.08	200.33	561033.0
2014-09-22 09:30:00	SPY	ETF	200.35	200.38	199.83	199.95	12184637.0
2014-09-22 10:00:00	SPY	ETF	199.955	200.23	199.57	199.69	8185934.0
2014-09-22 10:30:00	SPY	ETF	199.695	199.7	199.17	199.28	7496872.0
2014-09-22 11:00:00	SPY	ETF	199.27	199.45	199.12	199.34	6316241.0
2014-09-22 11:30:00	SPY	ETF	199.35	199.42	198.92	199.025	6780640.0
2014-09-22 12:00:00	SPY	ETF	199.03	199.155	198.85	199.06	7099183.0
2014-09-22 12:30:00	SPY	ETF	199.05	199.26	198.94	199.16	5185337.0
2014-09-22 13:00:00	SPY	ETF	199.16	199.33	198.94	199.2732	7645813.0
2014-09-22 13:30:00	SPY	ETF	199.28	199.37	199.035	199.035	5528737.0
2014-09-22 14:00:00	SPY	ETF	199.035	199.14	198.73	198.78	9026587.0
2014-09-22 14:30:00	SPY	ETF	198.79	199.14	198.78	199.035	5662987.0
2014-09-22 15:00:00	SPY	ETF	199.04	199.18	198.81	199.04	4587284.0
2014-09-22 15:30:00	SPY	ETF	199.05	199.29	198.95	199.14	13294401.0
2014-09-22 16:00:00	SPY	ETF	199.13	199.19	199.03	199.07	5374013.0
2014-09-22 16:30:00	SPY	ETF	199.05	199.15	198.96	198.97	18165357.0
2014-09-22 17:00:00	SPY	ETF	198.95	198.97	198.76	198.89	149542.0
2014-09-22 17:30:00	SPY	ETF	198.89	198.91	198.8	198.87	165124.0
2014-09-22 18:00:00	SPY	ETF	198.86	199.01	198.86	198.95	63265.0
2014-09-22 18:30:00	SPY	ETF	198.95	198.99	198.93	198.99	18924.0
2014-09-22 19:00:00	SPY	ETF	198.99	199.0	198.98	199.0	20900.0
2014-09-22 19:30:00	SPY	ETF	198.97	198.97	198.93	198.93	14227.0
2014-09-22 04:00:00	QQQ	ETF	99.37	99.49	99.37	99.49	9200.0
2014-09-22 04:30:00	QQQ	ETF	99.42	99.42	99.38	99.38	500.0
2014-09-22 05:00:00	QQQ	ETF	99.45	99.45	99.45	99.45	250.0
2014-09-22 05:30:00	QQQ	ETF	99.43	99.43	99.43	99.43	200.0
2014-09-22 06:00:00	QQQ	ETF	99.46	99.66	99.46	99.66	23050.0
2014-09-22 06:30:00	QQQ	ETF	99.66	99.66	99.63	99.65	20022.0
2014-09-22 07:00:00	QQQ	ETF	99.67	99.72	99.66	99.7	19700.0
2014-09-22 07:30:00	QQQ	ETF	99.66	99.67	99.64	99.64	7935.0
2014-09-22 08:00:00	QQQ	ETF	99.65	99.68	99.62	99.66	58876.0
2014-09-22 08:30:00	QQQ	ETF	99.66	99.73	99.56	99.63	139095.0
2014-09-22 09:00:00	QQQ	ETF	99.65	99.74	99.61	99.73	410297.0
2014-09-22 09:30:00	QQQ	ETF	99.74	99.75	99.46	99.52	5582310.0
2014-09-22 10:00:00	QQQ	ETF	99.52	99.67	99.11	99.2	4974722.0
2014-09-22 10:30:00	QQQ	ETF	99.21	99.21	98.86	98.93	3809658.0
2014-09-22 11:00:00	QQQ	ETF	98.93	99.04	98.75	98.965	3103998.0
2014-09-22 11:30:00	QQQ	ETF	98.97	99.03	98.68	98.78	2545889.0
2014-09-22 12:00:00	QQQ	ETF	98.78	98.85	98.64	98.795	2611023.0
2014-09-22 12:30:00	QQQ	ETF	98.79	98.9	98.69	98.841	1992563.0

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

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