PREVIEW / etf_30min / 2015-07-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-15.parquet
  size:    384 KB
  rows:    13,000

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
2015-07-15 04:00:00	SPY	ETF	210.79	210.9	210.77	210.9	11816.0
2015-07-15 04:30:00	SPY	ETF	210.85	210.95	210.8	210.92	2900.0
2015-07-15 05:00:00	SPY	ETF	210.92	210.95	210.85	210.85	10801.0
2015-07-15 05:30:00	SPY	ETF	210.89	210.89	210.85	210.87	2700.0
2015-07-15 06:00:00	SPY	ETF	210.84	210.89	210.84	210.89	2330.0
2015-07-15 06:30:00	SPY	ETF	210.84	210.87	210.79	210.8	8022.0
2015-07-15 07:00:00	SPY	ETF	210.85	210.98	210.85	210.9	60161.0
2015-07-15 07:30:00	SPY	ETF	210.9	210.98	210.9	210.92	58926.0
2015-07-15 08:00:00	SPY	ETF	210.92	210.93	210.81	210.83	142294.0
2015-07-15 08:30:00	SPY	ETF	210.81	210.9	210.74	210.77	277343.0
2015-07-15 09:00:00	SPY	ETF	210.77	210.83	210.63	210.75	656540.0
2015-07-15 09:30:00	SPY	ETF	210.73	210.97	210.51	210.82	9183777.0
2015-07-15 10:00:00	SPY	ETF	210.83	211.05	210.7	210.89	7201922.0
2015-07-15 10:30:00	SPY	ETF	210.88	211.2	210.855	211.105	4903395.0
2015-07-15 11:00:00	SPY	ETF	211.1	211.28	211.01	211.04	5312842.0
2015-07-15 11:30:00	SPY	ETF	211.03	211.12	210.81	210.895	4451849.0
2015-07-15 12:00:00	SPY	ETF	210.895	210.9999	210.78	210.9	4010851.0
2015-07-15 12:30:00	SPY	ETF	210.9	211.03	210.735	210.85	4003978.0
2015-07-15 13:00:00	SPY	ETF	210.85	211.05	210.75	210.97	2977399.0
2015-07-15 13:30:00	SPY	ETF	210.96	211.08	210.855	210.915	2493806.0
2015-07-15 14:00:00	SPY	ETF	210.915	211.0	210.84	210.929	2258105.0
2015-07-15 14:30:00	SPY	ETF	210.93	210.93	210.04	210.27	11748258.0
2015-07-15 15:00:00	SPY	ETF	210.27	210.46	210.17	210.4499	8938557.0
2015-07-15 15:30:00	SPY	ETF	210.449	210.66	210.32	210.63	15904799.0
2015-07-15 16:00:00	SPY	ETF	210.62	211.0206	210.51	210.95	3497203.0
2015-07-15 16:30:00	SPY	ETF	210.92	210.99	210.5688	210.94	642187.0
2015-07-15 17:00:00	SPY	ETF	210.96	211.08	210.61	210.94	2935020.0
2015-07-15 17:30:00	SPY	ETF	210.94	210.95	210.61	210.9	72100.0
2015-07-15 18:00:00	SPY	ETF	210.9	210.93	210.8	210.88	81791.0
2015-07-15 18:30:00	SPY	ETF	210.89	211.3	210.84	211.21	97781.0
2015-07-15 19:00:00	SPY	ETF	211.21	211.35	211.2	211.3	73531.0
2015-07-15 19:30:00	SPY	ETF	211.3	211.3	211.17	211.2	94149.0
2015-07-15 05:00:00	QQQ	ETF	110.49	110.49	110.49	110.49	2500.0
2015-07-15 05:30:00	QQQ	ETF	110.54	110.6	110.54	110.56	12600.0
2015-07-15 06:00:00	QQQ	ETF	110.47	110.5	110.46	110.49	14900.0
2015-07-15 06:30:00	QQQ	ETF	110.49	110.49	110.45	110.45	4000.0
2015-07-15 07:00:00	QQQ	ETF	110.49	110.5	110.49	110.5	700.0
2015-07-15 07:30:00	QQQ	ETF	110.49	110.52	110.49	110.5	14100.0
2015-07-15 08:00:00	QQQ	ETF	110.58	110.58	110.45	110.46	134625.0
2015-07-15 08:30:00	QQQ	ETF	110.5	110.5	110.46	110.46	17118.0
2015-07-15 09:00:00	QQQ	ETF	110.47	110.49	110.4	110.47	160156.0
2015-07-15 09:30:00	QQQ	ETF	110.47	110.7	110.317	110.67	3206331.0
2015-07-15 10:00:00	QQQ	ETF	110.68	110.77	110.5	110.51	2418587.0
2015-07-15 10:30:00	QQQ	ETF	110.5	110.74	110.49	110.69	1197229.0
2015-07-15 11:00:00	QQQ	ETF	110.69	110.81	110.63	110.652	1498242.0
2015-07-15 11:30:00	QQQ	ETF	110.66	110.73	110.51	110.59	1156638.0
2015-07-15 12:00:00	QQQ	ETF	110.58	110.6608	110.49	110.59	904759.0
2015-07-15 12:30:00	QQQ	ETF	110.59	110.67	110.46	110.54	1050963.0
2015-07-15 13:00:00	QQQ	ETF	110.55	110.63	110.48	110.6	844097.0
2015-07-15 13:30:00	QQQ	ETF	110.605	110.66	110.49	110.51	683406.0

> showing 50 of 13,000 rows — these rows as CSV

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