PREVIEW / etf_30min / 2013-12-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-20.parquet
  size:    347 KB
  rows:    11,677

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
2013-12-20 04:00:00	SPY	ETF	180.68	181.02	180.68	180.82	7262.0
2013-12-20 04:30:00	SPY	ETF	180.87	180.94	180.71	180.79	2769.0
2013-12-20 05:00:00	SPY	ETF	180.82	180.85	180.79	180.79	2220.0
2013-12-20 05:30:00	SPY	ETF	180.8	180.85	180.7	180.73	4517.0
2013-12-20 06:00:00	SPY	ETF	180.79	180.81	180.76	180.81	500.0
2013-12-20 06:30:00	SPY	ETF	180.79	180.8	180.63	180.67	9640.0
2013-12-20 07:00:00	SPY	ETF	180.68	181.6	180.51	180.51	129981.0
2013-12-20 07:30:00	SPY	ETF	180.51	180.61	180.51	180.58	364486.0
2013-12-20 08:00:00	SPY	ETF	180.59	180.67	180.53	180.61	1054901.0
2013-12-20 08:30:00	SPY	ETF	180.61	180.86	180.58	180.79	885940.0
2013-12-20 09:00:00	SPY	ETF	180.79	180.82	180.66	180.67	1677128.0
2013-12-20 09:30:00	SPY	ETF	180.67	181.44	180.66	181.33	19350944.0
2013-12-20 10:00:00	SPY	ETF	181.32	181.45	181.11	181.23	10883386.0
2013-12-20 10:30:00	SPY	ETF	181.23	181.55	181.15	181.35	9497950.0
2013-12-20 11:00:00	SPY	ETF	181.35	181.61	181.32	181.49	10006522.0
2013-12-20 11:30:00	SPY	ETF	181.5	181.79	181.49	181.75	8870654.0
2013-12-20 12:00:00	SPY	ETF	181.75	181.9	181.64	181.84	10284349.0
2013-12-20 12:30:00	SPY	ETF	181.84	181.91	181.79	181.8	5844282.0
2013-12-20 13:00:00	SPY	ETF	181.7901	181.88	181.79	181.83	4214528.0
2013-12-20 13:30:00	SPY	ETF	181.84	181.97	181.72	181.94	7946724.0
2013-12-20 14:00:00	SPY	ETF	181.94	181.99	181.84	181.9294	6198860.0
2013-12-20 14:30:00	SPY	ETF	181.93	181.98	181.85	181.89	6791860.0
2013-12-20 15:00:00	SPY	ETF	181.88	181.924	181.6	181.65	9490572.0
2013-12-20 15:30:00	SPY	ETF	181.65	181.81	181.46	181.55	25026331.0
2013-12-20 16:00:00	SPY	ETF	181.57	181.96	180.5683	181.68	11361783.0
2013-12-20 16:30:00	SPY	ETF	181.68	181.86	180.5486	181.85	8257696.0
2013-12-20 17:00:00	SPY	ETF	181.86	181.96	180.5683	181.87	24846964.0
2013-12-20 17:30:00	SPY	ETF	181.87	181.88	181.75	181.81	3170210.0
2013-12-20 18:00:00	SPY	ETF	181.81	182.0	181.81	181.92	130514.0
2013-12-20 18:30:00	SPY	ETF	181.92	181.93	181.64	181.75	141086.0
2013-12-20 19:00:00	SPY	ETF	181.74	181.97	181.7	181.9	107137.0
2013-12-20 19:30:00	SPY	ETF	181.9	181.9	181.83	181.9	28135.0
2013-12-20 04:00:00	QQQ	ETF	85.86	85.86	85.82	85.82	1408.0
2013-12-20 04:30:00	QQQ	ETF	85.8	85.8	85.8	85.8	354.0
2013-12-20 05:30:00	QQQ	ETF	85.78	85.78	85.74	85.77	1968.0
2013-12-20 06:00:00	QQQ	ETF	85.78	85.78	85.78	85.78	500.0
2013-12-20 06:30:00	QQQ	ETF	85.8	85.8	85.76	85.76	2400.0
2013-12-20 07:00:00	QQQ	ETF	85.77	85.77	85.7	85.7	2475.0
2013-12-20 07:30:00	QQQ	ETF	85.72	85.72	85.72	85.72	4000.0
2013-12-20 08:00:00	QQQ	ETF	85.74	86.12	85.7	85.74	30782.0
2013-12-20 08:30:00	QQQ	ETF	85.74	85.83	85.74	85.82	47427.0
2013-12-20 09:00:00	QQQ	ETF	85.84	85.86	85.73	85.75	261899.0
2013-12-20 09:30:00	QQQ	ETF	85.75	86.15	85.73	86.08	6781306.0
2013-12-20 10:00:00	QQQ	ETF	86.07	86.18	86.0199	86.13	3266250.0
2013-12-20 10:30:00	QQQ	ETF	86.13	86.345	86.12	86.3	2406748.0
2013-12-20 11:00:00	QQQ	ETF	86.29	86.44	86.27	86.39	1714694.0
2013-12-20 11:30:00	QQQ	ETF	86.39	86.53	86.39	86.5225	2262677.0
2013-12-20 12:00:00	QQQ	ETF	86.519	86.59	86.46	86.57	1793604.0
2013-12-20 12:30:00	QQQ	ETF	86.57	86.6	86.52	86.5399	1432870.0
2013-12-20 13:00:00	QQQ	ETF	86.53	86.6	86.53	86.579	1085007.0

> showing 50 of 11,677 rows — these rows as CSV

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