PREVIEW / etf_30min / 2014-12-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-15.parquet
  size:    389 KB
  rows:    12,977

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-12-15 04:00:00	SPY	ETF	201.52	201.9	201.52	201.85	7494.0
2014-12-15 04:30:00	SPY	ETF	202.0	202.1	201.81	202.1	58141.0
2014-12-15 05:00:00	SPY	ETF	202.08	202.16	201.92	201.97	23100.0
2014-12-15 05:30:00	SPY	ETF	201.92	201.98	201.75	201.89	18946.0
2014-12-15 06:00:00	SPY	ETF	201.89	201.9	201.57	201.78	9750.0
2014-12-15 06:30:00	SPY	ETF	201.72	201.97	201.7	201.85	201071.0
2014-12-15 07:00:00	SPY	ETF	201.75	201.79	201.7	201.78	62300.0
2014-12-15 07:30:00	SPY	ETF	201.79	201.88	201.57	201.66	189112.0
2014-12-15 08:00:00	SPY	ETF	201.77	201.89	201.04	201.88	729040.0
2014-12-15 08:30:00	SPY	ETF	201.87	201.9	201.37	201.51	862584.0
2014-12-15 09:00:00	SPY	ETF	201.51	202.08	201.48	201.99	1921957.0
2014-12-15 09:30:00	SPY	ETF	201.98	202.53	201.85	202.11	18122284.0
2014-12-15 10:00:00	SPY	ETF	202.1	202.11	200.98	201.19	13849640.0
2014-12-15 10:30:00	SPY	ETF	201.18	201.4	200.38	200.9965	14566635.0
2014-12-15 11:00:00	SPY	ETF	201.0	201.02	199.42	199.54	16851645.0
2014-12-15 11:30:00	SPY	ETF	199.53	199.9	198.78	198.96	18567388.0
2014-12-15 12:00:00	SPY	ETF	198.96	200.32	198.93	200.18	16395125.0
2014-12-15 12:30:00	SPY	ETF	200.18	200.9	199.8	200.705	11474310.0
2014-12-15 13:00:00	SPY	ETF	200.71	200.86	199.92	199.96	9989338.0
2014-12-15 13:30:00	SPY	ETF	199.95	200.37	199.75	199.97	7705497.0
2014-12-15 14:00:00	SPY	ETF	199.96	200.75	199.67	200.53	10625916.0
2014-12-15 14:30:00	SPY	ETF	200.52	200.8	199.75	199.96	10303869.0
2014-12-15 15:00:00	SPY	ETF	199.95	200.47	199.625	199.65	8378511.0
2014-12-15 15:30:00	SPY	ETF	199.65	200.2	199.44	199.48	19302786.0
2014-12-15 16:00:00	SPY	ETF	199.48	202.4	199.37	199.57	5529103.0
2014-12-15 16:30:00	SPY	ETF	199.56	199.59	199.37	199.52	669827.0
2014-12-15 17:00:00	SPY	ETF	199.54	199.74	199.51	199.63	223543.0
2014-12-15 17:30:00	SPY	ETF	199.63	199.74	199.6	199.74	126631.0
2014-12-15 18:00:00	SPY	ETF	199.75	199.85	199.67	199.69	140893.0
2014-12-15 18:30:00	SPY	ETF	199.69	199.95	199.69	199.94	121720.0
2014-12-15 19:00:00	SPY	ETF	199.94	200.17	199.93	199.99	159703.0
2014-12-15 19:30:00	SPY	ETF	199.93	199.97	199.84	199.92	81847.0
2014-12-15 04:00:00	QQQ	ETF	102.94	103.37	102.94	103.37	950.0
2014-12-15 04:30:00	QQQ	ETF	103.27	103.27	103.23	103.23	200.0
2014-12-15 05:00:00	QQQ	ETF	103.4	103.4	103.4	103.4	1000.0
2014-12-15 05:30:00	QQQ	ETF	103.27	103.28	103.25	103.25	26500.0
2014-12-15 06:00:00	QQQ	ETF	103.27	103.27	103.15	103.21	23900.0
2014-12-15 06:30:00	QQQ	ETF	103.2	103.3	103.2	103.28	7188.0
2014-12-15 07:00:00	QQQ	ETF	103.19	103.24	103.15	103.24	34100.0
2014-12-15 07:30:00	QQQ	ETF	103.25	103.3	103.21	103.21	9600.0
2014-12-15 08:00:00	QQQ	ETF	103.18	103.46	103.02	103.26	100722.0
2014-12-15 08:30:00	QQQ	ETF	103.23	103.23	102.951	103.05	103300.0
2014-12-15 09:00:00	QQQ	ETF	103.04	103.31	103.03	103.22	249179.0
2014-12-15 09:30:00	QQQ	ETF	103.2	103.58	103.01	103.19	5191704.0
2014-12-15 10:00:00	QQQ	ETF	103.18	103.2	102.64	102.78	4179295.0
2014-12-15 10:30:00	QQQ	ETF	102.78	102.86	102.1801	102.64	4847723.0
2014-12-15 11:00:00	QQQ	ETF	102.63	102.64	101.63	101.74	4742618.0
2014-12-15 11:30:00	QQQ	ETF	101.74	101.96	101.315	101.38	5500548.0
2014-12-15 12:00:00	QQQ	ETF	101.37	102.16	101.37	102.11	3395073.0
2014-12-15 12:30:00	QQQ	ETF	102.11	102.47	101.91	102.36	2483670.0

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

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