PREVIEW / etf_30min / 2010-03-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-24.parquet
  size:    248 KB
  rows:    8,423

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
2010-03-24 04:30:00	SPY	ETF	117.35	117.35	117.26	117.26	500.0
2010-03-24 06:00:00	SPY	ETF	117.18	117.18	116.77	116.83	25046.0
2010-03-24 06:30:00	SPY	ETF	116.79	116.92	116.75	116.92	16900.0
2010-03-24 07:00:00	SPY	ETF	116.93	117.16	116.91	117.1	524369.0
2010-03-24 07:30:00	SPY	ETF	117.12	117.12	116.99	117.03	626068.0
2010-03-24 08:00:00	SPY	ETF	117.03	117.21	116.97	117.0	1153057.0
2010-03-24 08:30:00	SPY	ETF	117.01	117.09	116.88	117.09	2216106.0
2010-03-24 09:00:00	SPY	ETF	117.09	117.15	116.91	116.96	1732141.0
2010-03-24 09:30:00	SPY	ETF	116.97	117.2	116.9	117.04	19645253.0
2010-03-24 10:00:00	SPY	ETF	117.03	117.32	116.87	117.15	17884368.0
2010-03-24 10:30:00	SPY	ETF	117.16	117.32	117.03	117.13	9644685.0
2010-03-24 11:00:00	SPY	ETF	117.125	117.21	116.61	116.82	18644820.0
2010-03-24 11:30:00	SPY	ETF	116.82	117.0	116.69	116.98	7302888.0
2010-03-24 12:00:00	SPY	ETF	116.98	117.4264	116.85	117.07	11159927.0
2010-03-24 12:30:00	SPY	ETF	117.07	117.22	117.05	117.081	6701617.0
2010-03-24 13:00:00	SPY	ETF	117.087	117.09	115.58	116.8498	18802301.0
2010-03-24 13:30:00	SPY	ETF	116.85	116.95	116.6	116.79	9496971.0
2010-03-24 14:00:00	SPY	ETF	116.7999	116.96	116.72	116.85	10339908.0
2010-03-24 14:30:00	SPY	ETF	116.86	116.93	116.73	116.78	6891427.0
2010-03-24 15:00:00	SPY	ETF	116.77	116.96	116.7	116.87	13863943.0
2010-03-24 15:30:00	SPY	ETF	116.87	117.09	116.79	116.82	18497358.0
2010-03-24 16:00:00	SPY	ETF	116.82	117.0363	116.82	116.88	11875053.0
2010-03-24 16:30:00	SPY	ETF	116.9	117.4263	116.82	116.88	1818516.0
2010-03-24 17:00:00	SPY	ETF	116.88	116.9	116.85	116.88	55229.0
2010-03-24 17:30:00	SPY	ETF	116.89	116.89	116.85	116.88	4916400.0
2010-03-24 18:00:00	SPY	ETF	116.89	116.9	116.86	116.86	29600.0
2010-03-24 18:30:00	SPY	ETF	116.87	116.89	116.86	116.86	19100.0
2010-03-24 19:00:00	SPY	ETF	116.87	116.93	116.87	116.9	35700.0
2010-03-24 19:30:00	SPY	ETF	116.91	116.95	116.91	116.91	37205.0
2010-03-24 04:00:00	QQQ	ETF	48.26	48.26	48.24	48.24	1400.0
2010-03-24 04:30:00	QQQ	ETF	48.25	48.28	48.21	48.21	1900.0
2010-03-24 05:00:00	QQQ	ETF	48.25	48.25	48.24	48.24	600.0
2010-03-24 05:30:00	QQQ	ETF	48.23	48.24	48.23	48.24	1980.0
2010-03-24 06:00:00	QQQ	ETF	48.07	48.07	48.07	48.07	6000.0
2010-03-24 06:30:00	QQQ	ETF	48.06	48.1	48.06	48.1	10000.0
2010-03-24 07:00:00	QQQ	ETF	48.14	48.17	48.13	48.17	78020.0
2010-03-24 07:30:00	QQQ	ETF	48.18	48.18	48.14	48.16	201697.0
2010-03-24 08:00:00	QQQ	ETF	48.17	48.26	48.15	48.19	257583.0
2010-03-24 08:30:00	QQQ	ETF	48.19	48.21	48.13	48.19	195050.0
2010-03-24 09:00:00	QQQ	ETF	48.19	48.2	48.11	48.13	582837.0
2010-03-24 09:30:00	QQQ	ETF	48.14	48.17	48.035	48.1	9964319.0
2010-03-24 10:00:00	QQQ	ETF	48.09	48.16	48.0	48.09	7690261.0
2010-03-24 10:30:00	QQQ	ETF	48.09	48.16	48.05	48.09	4033540.0
2010-03-24 11:00:00	QQQ	ETF	48.09	48.14	47.91	47.99	7066057.0
2010-03-24 11:30:00	QQQ	ETF	47.99	48.06	47.95	48.0502	4015995.0
2010-03-24 12:00:00	QQQ	ETF	48.055	48.08	48.03	48.05	2593940.0
2010-03-24 12:30:00	QQQ	ETF	48.06	48.11	48.04	48.06	1862881.0
2010-03-24 13:00:00	QQQ	ETF	48.05	48.06	47.95	47.999	2861425.0
2010-03-24 13:30:00	QQQ	ETF	48.0	48.05	47.93	48.0	2702009.0
2010-03-24 14:00:00	QQQ	ETF	48.01	48.06	47.96	48.01	3135707.0

> showing 50 of 8,423 rows — these rows as CSV

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