PREVIEW / etf_30min / 2012-01-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-03.parquet
  size:    297 KB
  rows:    10,106

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-01-03 04:00:00	SPY	ETF	128.3	128.58	128.1	128.55	103292.0
2012-01-03 04:30:00	SPY	ETF	128.52	128.55	128.44	128.51	159603.0
2012-01-03 05:00:00	SPY	ETF	128.55	128.6	128.4	128.49	45677.0
2012-01-03 05:30:00	SPY	ETF	128.54	128.54	128.14	128.25	23657.0
2012-01-03 06:00:00	SPY	ETF	128.1	128.15	127.8	128.1	175381.0
2012-01-03 06:30:00	SPY	ETF	128.2	128.24	127.88	127.9	134739.0
2012-01-03 07:00:00	SPY	ETF	127.96	127.98	127.76	127.76	279432.0
2012-01-03 07:30:00	SPY	ETF	127.75	127.8	127.52	127.59	348689.0
2012-01-03 08:00:00	SPY	ETF	127.57	128.09	125.5	127.53	842568.0
2012-01-03 08:30:00	SPY	ETF	127.54	128.2	125.5	127.7	504332.0
2012-01-03 09:00:00	SPY	ETF	127.7	127.89	127.67	127.78	1131626.0
2012-01-03 09:30:00	SPY	ETF	127.76	128.12	127.73	127.93	20724951.0
2012-01-03 10:00:00	SPY	ETF	127.93	128.38	127.83	128.2	18647335.0
2012-01-03 10:30:00	SPY	ETF	128.19	128.27	128.12	128.22	7012733.0
2012-01-03 11:00:00	SPY	ETF	128.22	128.34	128.14	128.18	7421253.0
2012-01-03 11:30:00	SPY	ETF	128.17	128.24	127.9	127.95	8220779.0
2012-01-03 12:00:00	SPY	ETF	127.95	127.98	127.83	127.94	6836419.0
2012-01-03 12:30:00	SPY	ETF	127.93	127.94	127.43	127.529	15987362.0
2012-01-03 13:00:00	SPY	ETF	127.54	127.65	127.48	127.58	9541638.0
2012-01-03 13:30:00	SPY	ETF	127.58	127.8308	127.47	127.705	7918683.0
2012-01-03 14:00:00	SPY	ETF	127.71	127.85	127.67	127.85	6308730.0
2012-01-03 14:30:00	SPY	ETF	127.84	128.07	127.79	128.05	12573651.0
2012-01-03 15:00:00	SPY	ETF	128.05	128.06	127.67	127.78	9575756.0
2012-01-03 15:30:00	SPY	ETF	127.772	128.01	127.48	127.59	23215830.0
2012-01-03 16:00:00	SPY	ETF	127.58	128.265	125.6613	127.64	22256104.0
2012-01-03 16:30:00	SPY	ETF	127.63	127.75	127.58	127.73	3231225.0
2012-01-03 17:00:00	SPY	ETF	127.73	127.78	127.67	127.78	96731.0
2012-01-03 17:30:00	SPY	ETF	127.78	127.78	127.69	127.72	47164.0
2012-01-03 18:00:00	SPY	ETF	127.71	127.76	127.49	127.69	251944.0
2012-01-03 18:30:00	SPY	ETF	127.67	127.75	127.64	127.67	35730.0
2012-01-03 19:00:00	SPY	ETF	127.66	127.73	127.64	127.7	16610.0
2012-01-03 19:30:00	SPY	ETF	127.64	127.71	127.62	127.65	85430.0
2012-01-03 04:00:00	QQQ	ETF	56.76	56.9	56.76	56.9	1600.0
2012-01-03 04:30:00	QQQ	ETF	57.05	57.05	57.05	57.05	200.0
2012-01-03 06:00:00	QQQ	ETF	56.75	56.86	56.75	56.86	2100.0
2012-01-03 06:30:00	QQQ	ETF	56.95	56.95	56.92	56.95	2442.0
2012-01-03 07:00:00	QQQ	ETF	56.96	57.0	56.93	56.96	16450.0
2012-01-03 07:30:00	QQQ	ETF	56.94	56.94	56.79	56.81	46529.0
2012-01-03 08:00:00	QQQ	ETF	56.8	56.96	56.7	56.72	408397.0
2012-01-03 08:30:00	QQQ	ETF	56.72	56.78	55.83	56.77	563182.0
2012-01-03 09:00:00	QQQ	ETF	56.77	56.91	56.76	56.9	1130603.0
2012-01-03 09:30:00	QQQ	ETF	56.91	57.189	56.86	57.03	5082896.0
2012-01-03 10:00:00	QQQ	ETF	57.04	57.19	56.99	57.1	3259539.0
2012-01-03 10:30:00	QQQ	ETF	57.11	57.189	57.08	57.14	1724351.0
2012-01-03 11:00:00	QQQ	ETF	57.14	57.17	57.06	57.09	1299243.0
2012-01-03 11:30:00	QQQ	ETF	57.09	57.12	56.98	57.01	1651867.0
2012-01-03 12:00:00	QQQ	ETF	57.01	57.055	56.931	56.981	1251681.0
2012-01-03 12:30:00	QQQ	ETF	56.98	56.98	56.75	56.84	2896596.0
2012-01-03 13:00:00	QQQ	ETF	56.8498	56.92	56.8	56.85	1983117.0
2012-01-03 13:30:00	QQQ	ETF	56.848	56.94	56.78	56.92	1628051.0

> showing 50 of 10,106 rows — these rows as CSV

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