PREVIEW / etf_30min / 2010-09-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-21.parquet
  size:    266 KB
  rows:    8,826

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-09-21 04:00:00	SPY	ETF	114.0	114.1	113.98	114.1	8500.0
2010-09-21 04:30:00	SPY	ETF	114.06	114.06	114.0	114.0	1000.0
2010-09-21 05:00:00	SPY	ETF	114.07	114.25	114.07	114.25	284.0
2010-09-21 05:30:00	SPY	ETF	114.24	114.24	114.11	114.11	700.0
2010-09-21 06:00:00	SPY	ETF	114.01	114.01	113.96	113.96	600.0
2010-09-21 06:30:00	SPY	ETF	114.02	114.06	114.0	114.06	12550.0
2010-09-21 07:00:00	SPY	ETF	114.06	114.21	114.01	114.15	129425.0
2010-09-21 07:30:00	SPY	ETF	114.18	114.18	114.04	114.12	158495.0
2010-09-21 08:00:00	SPY	ETF	114.15	114.23	113.76	113.91	1020524.0
2010-09-21 08:30:00	SPY	ETF	113.94	114.37	113.94	114.29	2097758.0
2010-09-21 09:00:00	SPY	ETF	114.29	114.42	114.26	114.29	1880930.0
2010-09-21 09:30:00	SPY	ETF	114.3	114.34	114.01	114.1	19309143.0
2010-09-21 10:00:00	SPY	ETF	114.1	114.26	114.02	114.11	10052803.0
2010-09-21 10:30:00	SPY	ETF	114.12	114.25	114.03	114.08	11221188.0
2010-09-21 11:00:00	SPY	ETF	114.09	114.19	113.85	113.87	11646316.0
2010-09-21 11:30:00	SPY	ETF	113.86	113.99	113.83	113.95	6360410.0
2010-09-21 12:00:00	SPY	ETF	113.95	114.04	113.84	113.84	3446867.0
2010-09-21 12:30:00	SPY	ETF	113.8423	113.97	113.83	113.96	4084188.0
2010-09-21 13:00:00	SPY	ETF	113.96	113.96	113.76	113.8099	5753909.0
2010-09-21 13:30:00	SPY	ETF	113.81	113.91	113.71	113.86	6463431.0
2010-09-21 14:00:00	SPY	ETF	113.85	114.45	113.51	114.26	33113308.0
2010-09-21 14:30:00	SPY	ETF	114.27	114.84	114.16	114.43	41312915.0
2010-09-21 15:00:00	SPY	ETF	114.43	114.46	114.01	114.15	24544198.0
2010-09-21 15:30:00	SPY	ETF	114.19	114.5665	113.6	114.0	59817864.0
2010-09-21 16:00:00	SPY	ETF	113.98	114.815	113.555	113.93	17119737.0
2010-09-21 16:30:00	SPY	ETF	113.95	114.1694	113.81	113.85	364219.0
2010-09-21 17:00:00	SPY	ETF	113.86	114.2323	113.75	113.82	4125349.0
2010-09-21 17:30:00	SPY	ETF	113.81	113.85	113.79	113.82	42320.0
2010-09-21 18:00:00	SPY	ETF	113.8	114.0	113.77	113.84	48124.0
2010-09-21 18:30:00	SPY	ETF	113.84	113.94	113.84	113.87	69500.0
2010-09-21 19:00:00	SPY	ETF	113.88	113.94	113.84	113.93	45748.0
2010-09-21 19:30:00	SPY	ETF	113.93	113.98	113.8	113.87	105497.0
2010-09-21 05:30:00	QQQ	ETF	48.81	48.81	48.81	48.81	100.0
2010-09-21 06:00:00	QQQ	ETF	48.74	48.77	48.74	48.77	7600.0
2010-09-21 06:30:00	QQQ	ETF	48.77	48.78	48.77	48.78	50052.0
2010-09-21 07:00:00	QQQ	ETF	48.79	48.82	48.79	48.8	14000.0
2010-09-21 07:30:00	QQQ	ETF	48.77	48.81	48.76	48.81	14252.0
2010-09-21 08:00:00	QQQ	ETF	48.8	48.82	48.63	48.69	123672.0
2010-09-21 08:30:00	QQQ	ETF	48.69	48.85	48.67	48.82	931095.0
2010-09-21 09:00:00	QQQ	ETF	48.83	48.89	48.81	48.84	326920.0
2010-09-21 09:30:00	QQQ	ETF	48.84	48.86	48.69	48.77	7312404.0
2010-09-21 10:00:00	QQQ	ETF	48.77	48.87	48.75	48.83	4941929.0
2010-09-21 10:30:00	QQQ	ETF	48.83	48.91	48.76	48.8	4543896.0
2010-09-21 11:00:00	QQQ	ETF	48.79	48.86	48.72	48.73	3502364.0
2010-09-21 11:30:00	QQQ	ETF	48.72	48.79	48.71	48.77	1884749.0
2010-09-21 12:00:00	QQQ	ETF	48.76	48.82	48.73	48.77	1980972.0
2010-09-21 12:30:00	QQQ	ETF	48.77	48.83	48.75	48.82	955831.0
2010-09-21 13:00:00	QQQ	ETF	48.82	48.82	48.74	48.77	1983902.0
2010-09-21 13:30:00	QQQ	ETF	48.78	48.8	48.71	48.79	1881806.0
2010-09-21 14:00:00	QQQ	ETF	48.79	49.0	48.66	48.93	10470350.0

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

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