PREVIEW / etf_30min / 2012-11-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-29.parquet
  size:    288 KB
  rows:    9,929

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-11-29 04:00:00	SPY	ETF	142.21	142.37	142.21	142.21	5845.0
2012-11-29 04:30:00	SPY	ETF	142.22	142.34	142.22	142.31	75548.0
2012-11-29 05:00:00	SPY	ETF	142.23	142.26	142.13	142.24	68348.0
2012-11-29 05:30:00	SPY	ETF	142.22	142.25	142.15	142.17	115575.0
2012-11-29 06:00:00	SPY	ETF	142.18	142.24	142.14	142.2	69850.0
2012-11-29 06:30:00	SPY	ETF	142.2	142.35	142.17	142.21	67361.0
2012-11-29 07:00:00	SPY	ETF	142.21	142.27	142.09	142.17	325266.0
2012-11-29 07:30:00	SPY	ETF	142.19	142.3	142.19	142.275	156987.0
2012-11-29 08:00:00	SPY	ETF	142.28	142.28	142.12	142.16	332569.0
2012-11-29 08:30:00	SPY	ETF	142.11	142.23	141.48	141.96	857649.0
2012-11-29 09:00:00	SPY	ETF	141.96	142.14	141.91	141.99	573345.0
2012-11-29 09:30:00	SPY	ETF	141.99	142.42	141.985	142.36	16266436.0
2012-11-29 10:00:00	SPY	ETF	142.36	142.51	141.75	142.07	18213170.0
2012-11-29 10:30:00	SPY	ETF	142.05	142.28	141.895	142.18	8793318.0
2012-11-29 11:00:00	SPY	ETF	142.18	142.35	142.06	142.149	7494373.0
2012-11-29 11:30:00	SPY	ETF	142.14	142.22	141.37	141.72	26472084.0
2012-11-29 12:00:00	SPY	ETF	141.72	142.13	141.555	142.03	12456347.0
2012-11-29 12:30:00	SPY	ETF	142.04	142.12	141.92	141.98	4499493.0
2012-11-29 13:00:00	SPY	ETF	141.98	142.12	141.88	142.11	4474145.0
2012-11-29 13:30:00	SPY	ETF	142.11	142.39	142.1	142.2622	5853170.0
2012-11-29 14:00:00	SPY	ETF	142.261	142.3	142.17	142.2	4131027.0
2012-11-29 14:30:00	SPY	ETF	142.2	142.37	142.2	142.23	4739972.0
2012-11-29 15:00:00	SPY	ETF	142.23	142.25	141.81	142.0	8883909.0
2012-11-29 15:30:00	SPY	ETF	141.99	142.28	141.93	142.14	15390131.0
2012-11-29 16:00:00	SPY	ETF	142.13	142.32	141.5114	142.27	6086319.0
2012-11-29 16:30:00	SPY	ETF	142.27	142.29	141.5114	142.14	2231408.0
2012-11-29 17:00:00	SPY	ETF	142.14	142.14	141.83	141.84	1607789.0
2012-11-29 17:30:00	SPY	ETF	141.84	141.86	141.78	141.83	174061.0
2012-11-29 18:00:00	SPY	ETF	141.83	141.84	141.65	141.73	164594.0
2012-11-29 18:30:00	SPY	ETF	141.73	141.82	141.73	141.76	22394.0
2012-11-29 19:00:00	SPY	ETF	141.77	141.79	141.69	141.71	43310.0
2012-11-29 19:30:00	SPY	ETF	141.7	141.87	141.7	141.81	65049.0
2012-11-29 04:00:00	QQQ	ETF	65.91	65.97	65.91	65.95	136387.0
2012-11-29 04:30:00	QQQ	ETF	65.99	66.0	65.97	66.0	59100.0
2012-11-29 05:00:00	QQQ	ETF	65.95	65.95	65.93	65.93	21600.0
2012-11-29 05:30:00	QQQ	ETF	65.91	65.95	65.91	65.94	105700.0
2012-11-29 06:00:00	QQQ	ETF	65.94	65.95	65.91	65.92	58700.0
2012-11-29 06:30:00	QQQ	ETF	65.92	65.98	65.9	65.91	40500.0
2012-11-29 07:00:00	QQQ	ETF	65.91	65.94	65.9	65.92	10100.0
2012-11-29 07:30:00	QQQ	ETF	65.93	65.95	65.92	65.935	107046.0
2012-11-29 08:00:00	QQQ	ETF	65.93	66.02	65.88	65.92	247632.0
2012-11-29 08:30:00	QQQ	ETF	65.88	65.93	65.81	65.81	112301.0
2012-11-29 09:00:00	QQQ	ETF	65.81	65.89	65.76	65.81	150584.0
2012-11-29 09:30:00	QQQ	ETF	65.82	66.13	65.82	66.04	7182219.0
2012-11-29 10:00:00	QQQ	ETF	66.04	66.135	65.75	65.895	5843791.0
2012-11-29 10:30:00	QQQ	ETF	65.89	66.06	65.83	66.03	2707474.0
2012-11-29 11:00:00	QQQ	ETF	66.04	66.06	65.89	65.918	1329659.0
2012-11-29 11:30:00	QQQ	ETF	65.92	65.95	65.58	65.78	5937824.0
2012-11-29 12:00:00	QQQ	ETF	65.78	65.97	65.67	65.9	2688732.0
2012-11-29 12:30:00	QQQ	ETF	65.9	65.935	65.85	65.861	671626.0

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

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