PREVIEW / etf_30min / 2011-05-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-02.parquet
  size:    289 KB
  rows:    9,576

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
2011-05-02 04:00:00	SPY	ETF	137.0	137.29	137.0	137.24	15355.0
2011-05-02 04:30:00	SPY	ETF	137.32	137.38	137.29	137.31	3300.0
2011-05-02 05:00:00	SPY	ETF	137.26	137.3	137.24	137.24	1200.0
2011-05-02 05:30:00	SPY	ETF	137.31	137.31	137.19	137.21	7200.0
2011-05-02 06:00:00	SPY	ETF	137.21	137.21	137.18	137.21	3965.0
2011-05-02 06:30:00	SPY	ETF	137.24	137.24	137.0	137.09	47175.0
2011-05-02 07:00:00	SPY	ETF	137.09	137.15	137.05	137.1	154200.0
2011-05-02 07:30:00	SPY	ETF	137.11	137.15	137.08	137.15	346752.0
2011-05-02 08:00:00	SPY	ETF	137.14	137.6	137.0025	137.09	1783644.0
2011-05-02 08:30:00	SPY	ETF	137.08	137.21	137.08	137.17	475574.0
2011-05-02 09:00:00	SPY	ETF	137.18	137.2	136.43	137.08	711697.0
2011-05-02 09:30:00	SPY	ETF	137.07	137.1	136.66	136.85	17996819.0
2011-05-02 10:00:00	SPY	ETF	136.85	137.12	136.76	137.1	10641437.0
2011-05-02 10:30:00	SPY	ETF	137.09	137.18	136.995	137.02	6514708.0
2011-05-02 11:00:00	SPY	ETF	137.025	137.11	136.78	136.78	6663622.0
2011-05-02 11:30:00	SPY	ETF	136.78	136.82	136.58	136.65	8418610.0
2011-05-02 12:00:00	SPY	ETF	136.64	136.71	136.25	136.27	11392508.0
2011-05-02 12:30:00	SPY	ETF	136.27	136.4	136.15	136.31	12819502.0
2011-05-02 13:00:00	SPY	ETF	136.31	136.58	136.3	136.56	4050573.0
2011-05-02 13:30:00	SPY	ETF	136.56	136.58	136.45	136.5	3174241.0
2011-05-02 14:00:00	SPY	ETF	136.5	136.65	136.41	136.45	4094031.0
2011-05-02 14:30:00	SPY	ETF	136.45	136.5	136.24	136.27	5309862.0
2011-05-02 15:00:00	SPY	ETF	136.26	136.41	136.14	136.17	6912280.0
2011-05-02 15:30:00	SPY	ETF	136.18	136.28	135.95	136.23	18607172.0
2011-05-02 16:00:00	SPY	ETF	136.23	136.3	136.16	136.21	5067418.0
2011-05-02 16:30:00	SPY	ETF	136.21	136.3	136.19	136.21	484778.0
2011-05-02 17:00:00	SPY	ETF	136.2	136.21	136.16	136.16	113264.0
2011-05-02 17:30:00	SPY	ETF	136.17	136.2	136.16	136.19	12350.0
2011-05-02 18:00:00	SPY	ETF	136.19	136.25	136.15	136.15	35045.0
2011-05-02 18:30:00	SPY	ETF	136.18	136.2	136.15	136.17	19190.0
2011-05-02 19:00:00	SPY	ETF	136.16	136.2	136.14	136.17	21330.0
2011-05-02 19:30:00	SPY	ETF	136.15	136.19	136.12	136.12	68239.0
2011-05-02 04:00:00	QQQ	ETF	59.4	59.4	59.34	59.34	1063.0
2011-05-02 05:00:00	QQQ	ETF	59.37	59.37	59.37	59.37	100.0
2011-05-02 06:00:00	QQQ	ETF	59.37	59.37	59.37	59.37	100.0
2011-05-02 06:30:00	QQQ	ETF	59.31	59.32	59.27	59.29	61400.0
2011-05-02 07:00:00	QQQ	ETF	59.29	59.29	59.25	59.28	32800.0
2011-05-02 07:30:00	QQQ	ETF	59.28	59.3	59.27	59.3	36086.0
2011-05-02 08:00:00	QQQ	ETF	59.29	59.31	59.24	59.25	83922.0
2011-05-02 08:30:00	QQQ	ETF	59.25	59.29	59.25	59.27	260914.0
2011-05-02 09:00:00	QQQ	ETF	59.27	59.28	59.14	59.19	680267.0
2011-05-02 09:30:00	QQQ	ETF	59.19	59.19	58.99	59.06	6273342.0
2011-05-02 10:00:00	QQQ	ETF	59.07	59.27	59.02	59.26	3878407.0
2011-05-02 10:30:00	QQQ	ETF	59.2631	59.34	59.23	59.25	4346415.0
2011-05-02 11:00:00	QQQ	ETF	59.25	59.31	59.12	59.13	3173439.0
2011-05-02 11:30:00	QQQ	ETF	59.13	59.13	59.0	59.051	2401855.0
2011-05-02 12:00:00	QQQ	ETF	59.05	59.11	58.88	58.89	3475280.0
2011-05-02 12:30:00	QQQ	ETF	58.89	58.99	58.82	58.94	2851562.0
2011-05-02 13:00:00	QQQ	ETF	58.94	59.14	58.93	59.14	1859037.0
2011-05-02 13:30:00	QQQ	ETF	59.14	59.14	59.08	59.12	3659344.0

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

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