PREVIEW / etf_30min / 2012-07-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-24.parquet
  size:    293 KB
  rows:    9,762

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
2012-07-24 04:00:00	SPY	ETF	134.74	134.91	134.68	134.91	3300.0
2012-07-24 04:30:00	SPY	ETF	134.9	135.05	134.85	134.95	7700.0
2012-07-24 05:00:00	SPY	ETF	134.94	135.01	134.83	134.93	8850.0
2012-07-24 05:30:00	SPY	ETF	134.92	135.0	134.88	134.93	24000.0
2012-07-24 06:00:00	SPY	ETF	134.89	134.98	134.56	134.56	22530.0
2012-07-24 06:30:00	SPY	ETF	134.6	134.71	134.49	134.68	46097.0
2012-07-24 07:00:00	SPY	ETF	134.64	134.91	134.62	134.76	113915.0
2012-07-24 07:30:00	SPY	ETF	134.75	134.75	134.56	134.7	274465.0
2012-07-24 08:00:00	SPY	ETF	134.7	134.81	134.6	134.78	255608.0
2012-07-24 08:30:00	SPY	ETF	134.77	134.88	134.61	134.87	483650.0
2012-07-24 09:00:00	SPY	ETF	134.87	135.27	134.86	135.18	901968.0
2012-07-24 09:30:00	SPY	ETF	135.19	135.25	134.65	134.66	11815144.0
2012-07-24 10:00:00	SPY	ETF	134.66	135.17	134.18	134.3	10655573.0
2012-07-24 10:30:00	SPY	ETF	134.298	135.21	134.13	134.33	8306686.0
2012-07-24 11:00:00	SPY	ETF	134.33	135.1	134.18	134.42	8173752.0
2012-07-24 11:30:00	SPY	ETF	134.41	134.48	133.86	133.92	12496132.0
2012-07-24 12:00:00	SPY	ETF	133.92	135.02	133.25	133.424	14208542.0
2012-07-24 12:30:00	SPY	ETF	133.42	133.75	133.39	133.72	7018983.0
2012-07-24 13:00:00	SPY	ETF	133.725	133.77	133.44	133.51	4612916.0
2012-07-24 13:30:00	SPY	ETF	133.51	134.97	133.36	133.55	6435072.0
2012-07-24 14:00:00	SPY	ETF	133.55	133.57	133.1	133.1	8650308.0
2012-07-24 14:30:00	SPY	ETF	133.11	134.95	133.03	133.32	9113198.0
2012-07-24 15:00:00	SPY	ETF	133.32	134.92	133.05	133.67	14617036.0
2012-07-24 15:30:00	SPY	ETF	133.68	135.1719	133.445	133.99	29960276.0
2012-07-24 16:00:00	SPY	ETF	134.0	135.1715	133.51	133.7	16989730.0
2012-07-24 16:30:00	SPY	ETF	133.66	133.95	132.76	132.84	2480931.0
2012-07-24 17:00:00	SPY	ETF	132.84	133.05	132.82	132.98	402139.0
2012-07-24 17:30:00	SPY	ETF	132.99	133.03	132.92	132.96	1101967.0
2012-07-24 18:00:00	SPY	ETF	132.98	133.02	132.92	133.02	61325.0
2012-07-24 18:30:00	SPY	ETF	133.0	133.02	132.87	132.93	122454.0
2012-07-24 19:00:00	SPY	ETF	132.91	132.99	132.91	132.94	37961.0
2012-07-24 19:30:00	SPY	ETF	132.95	133.06	132.95	132.98	50162.0
2012-07-24 06:00:00	QQQ	ETF	63.24	63.24	63.19	63.19	300.0
2012-07-24 06:30:00	QQQ	ETF	63.16	63.23	63.16	63.23	600.0
2012-07-24 07:00:00	QQQ	ETF	63.2	63.4	63.2	63.34	7000.0
2012-07-24 07:30:00	QQQ	ETF	63.3	63.3	63.23	63.27	15297.0
2012-07-24 08:00:00	QQQ	ETF	63.25	63.42	63.25	63.42	89339.0
2012-07-24 08:30:00	QQQ	ETF	63.41	63.49	63.34	63.49	483187.0
2012-07-24 09:00:00	QQQ	ETF	63.5	63.63	63.5	63.57	488624.0
2012-07-24 09:30:00	QQQ	ETF	63.58	63.66	63.29	63.37	3512175.0
2012-07-24 10:00:00	QQQ	ETF	63.37	63.46	63.14	63.2499	3313450.0
2012-07-24 10:30:00	QQQ	ETF	63.24	63.4	63.18	63.27	2023531.0
2012-07-24 11:00:00	QQQ	ETF	63.275	63.46	63.2	63.36	1882832.0
2012-07-24 11:30:00	QQQ	ETF	63.36	63.41	63.15	63.17	1897350.0
2012-07-24 12:00:00	QQQ	ETF	63.175	63.18	62.78	62.871	2564251.0
2012-07-24 12:30:00	QQQ	ETF	62.88	63.08	62.84	63.06	1607052.0
2012-07-24 13:00:00	QQQ	ETF	63.05	63.08	62.87	62.92	960481.0
2012-07-24 13:30:00	QQQ	ETF	62.92	63.04	62.83	62.96	1682979.0
2012-07-24 14:00:00	QQQ	ETF	62.97	62.97	62.73	62.76	2005718.0
2012-07-24 14:30:00	QQQ	ETF	62.76	62.81	62.68	62.77	5269639.0

> showing 50 of 9,762 rows — these rows as CSV

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