PREVIEW / etf_30min / 2010-08-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-26.parquet
  size:    255 KB
  rows:    8,469

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-08-26 04:00:00	SPY	ETF	106.25	106.35	106.04	106.04	14200.0
2010-08-26 04:30:00	SPY	ETF	106.19	106.19	106.19	106.19	100.0
2010-08-26 05:00:00	SPY	ETF	106.13	106.13	106.13	106.13	200.0
2010-08-26 06:00:00	SPY	ETF	106.38	106.41	106.35	106.35	9400.0
2010-08-26 06:30:00	SPY	ETF	106.27	106.33	106.14	106.16	34650.0
2010-08-26 07:00:00	SPY	ETF	106.24	106.24	106.06	106.22	95184.0
2010-08-26 07:30:00	SPY	ETF	106.22	106.24	106.04	106.04	186490.0
2010-08-26 08:00:00	SPY	ETF	106.04	106.26	105.91	106.15	1796074.0
2010-08-26 08:30:00	SPY	ETF	106.2	106.74	106.19	106.57	4473458.0
2010-08-26 09:00:00	SPY	ETF	106.57	106.57	106.32	106.43	1916444.0
2010-08-26 09:30:00	SPY	ETF	106.44	106.46	105.9	106.2	27038706.0
2010-08-26 10:00:00	SPY	ETF	106.2	106.55	106.17	106.29	20667632.0
2010-08-26 10:30:00	SPY	ETF	106.29	106.58	106.18	106.29	12508427.0
2010-08-26 11:00:00	SPY	ETF	106.2918	106.32	105.67	105.95	17078248.0
2010-08-26 11:30:00	SPY	ETF	105.95	106.08	105.61	105.99	10544419.0
2010-08-26 12:00:00	SPY	ETF	105.99	106.01	105.72	105.89	4977408.0
2010-08-26 12:30:00	SPY	ETF	105.89	105.97	105.57	105.84	12731640.0
2010-08-26 13:00:00	SPY	ETF	105.84	105.87	105.62	105.78	3934128.0
2010-08-26 13:30:00	SPY	ETF	105.77	105.89	105.55	105.57	5213505.0
2010-08-26 14:00:00	SPY	ETF	105.56	105.67	105.19	105.29	14917482.0
2010-08-26 14:30:00	SPY	ETF	105.29	105.37	104.88	104.99	14773750.0
2010-08-26 15:00:00	SPY	ETF	104.98	105.5	104.96	105.34	20688012.0
2010-08-26 15:30:00	SPY	ETF	105.33	105.68	105.1	105.2	32167623.0
2010-08-26 16:00:00	SPY	ETF	105.22	106.32	104.9	104.93	12208907.0
2010-08-26 16:30:00	SPY	ETF	104.92	105.16	104.82	104.91	1696314.0
2010-08-26 17:00:00	SPY	ETF	104.94	105.9262	104.75	104.82	1287422.0
2010-08-26 17:30:00	SPY	ETF	104.89	104.89	104.76	104.82	38287.0
2010-08-26 18:00:00	SPY	ETF	104.82	105.23	104.82	104.95	150514.0
2010-08-26 18:30:00	SPY	ETF	104.93	104.97	104.89	104.97	14768.0
2010-08-26 19:00:00	SPY	ETF	104.96	104.97	104.9	104.93	27250.0
2010-08-26 19:30:00	SPY	ETF	104.94	105.0	104.86	104.98	82074.0
2010-08-26 04:00:00	QQQ	ETF	44.17	44.2	44.16	44.17	19300.0
2010-08-26 05:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	1000.0
2010-08-26 06:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	202.0
2010-08-26 07:00:00	QQQ	ETF	44.11	44.12	44.06	44.12	10500.0
2010-08-26 07:30:00	QQQ	ETF	44.12	44.12	44.03	44.03	62900.0
2010-08-26 08:00:00	QQQ	ETF	44.04	44.18	43.98	44.13	2246715.0
2010-08-26 08:30:00	QQQ	ETF	44.21	44.37	44.21	44.3	1810891.0
2010-08-26 09:00:00	QQQ	ETF	44.3	44.33	44.2	44.24	2379489.0
2010-08-26 09:30:00	QQQ	ETF	44.24	44.28	44.01	44.19	11052692.0
2010-08-26 10:00:00	QQQ	ETF	44.19	44.32	44.08	44.12	7159219.0
2010-08-26 10:30:00	QQQ	ETF	44.12	44.23	44.0	44.06	5097175.0
2010-08-26 11:00:00	QQQ	ETF	44.06	44.07	43.79	43.94	6666956.0
2010-08-26 11:30:00	QQQ	ETF	43.95	44.02	43.79	43.97	4919660.0
2010-08-26 12:00:00	QQQ	ETF	43.97	43.98	43.83	43.93	1533787.0
2010-08-26 12:30:00	QQQ	ETF	43.93	43.98	43.78	43.89	2846678.0
2010-08-26 13:00:00	QQQ	ETF	43.89	43.9	43.79	43.88	1576381.0
2010-08-26 13:30:00	QQQ	ETF	43.875	43.93	43.75	43.7699	2470605.0
2010-08-26 14:00:00	QQQ	ETF	43.76	43.81	43.6	43.63	4123448.0
2010-08-26 14:30:00	QQQ	ETF	43.63	43.7	43.5	43.55	4468461.0

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

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