PREVIEW / etf_30min / 2011-12-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-28.parquet
  size:    279 KB
  rows:    9,369

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-12-28 04:30:00	SPY	ETF	126.47	126.47	126.46	126.46	8159.0
2011-12-28 05:00:00	SPY	ETF	126.47	126.67	126.47	126.64	26563.0
2011-12-28 05:30:00	SPY	ETF	126.65	126.77	126.65	126.74	26800.0
2011-12-28 06:00:00	SPY	ETF	126.75	126.77	126.67	126.7	19300.0
2011-12-28 06:30:00	SPY	ETF	126.72	126.8	126.7	126.76	319200.0
2011-12-28 07:00:00	SPY	ETF	126.74	126.85	126.69	126.78	45650.0
2011-12-28 07:30:00	SPY	ETF	126.78	126.81	126.72	126.72	318600.0
2011-12-28 08:00:00	SPY	ETF	126.69	126.78	126.03	126.69	206440.0
2011-12-28 08:30:00	SPY	ETF	126.72	126.79	126.65	126.71	298081.0
2011-12-28 09:00:00	SPY	ETF	126.71	126.73	126.32	126.5	1456157.0
2011-12-28 09:30:00	SPY	ETF	126.51	126.53	125.65	125.74	18296521.0
2011-12-28 10:00:00	SPY	ETF	125.75	125.94	125.36	125.4	10433179.0
2011-12-28 10:30:00	SPY	ETF	125.39	125.52	125.23	125.411	7575622.0
2011-12-28 11:00:00	SPY	ETF	125.42	125.46	125.11	125.11	6792456.0
2011-12-28 11:30:00	SPY	ETF	125.11	125.19	124.87	125.06	8596847.0
2011-12-28 12:00:00	SPY	ETF	125.06	125.1587	124.87	125.09	5885511.0
2011-12-28 12:30:00	SPY	ETF	125.08	125.16	124.92	124.949	4495704.0
2011-12-28 13:00:00	SPY	ETF	124.95	125.151	124.92	125.14	5390176.0
2011-12-28 13:30:00	SPY	ETF	125.14	125.32	125.13	125.29	4725180.0
2011-12-28 14:00:00	SPY	ETF	125.29	125.3	124.96	125.13	6598000.0
2011-12-28 14:30:00	SPY	ETF	125.13	125.14	124.94	125.01	4864521.0
2011-12-28 15:00:00	SPY	ETF	125.0	125.15	124.73	124.7826	8727661.0
2011-12-28 15:30:00	SPY	ETF	124.78	125.01	124.73	124.96	16155387.0
2011-12-28 16:00:00	SPY	ETF	124.96	126.4299	124.78	125.218	4811209.0
2011-12-28 16:30:00	SPY	ETF	124.84	124.97	124.82	124.93	719766.0
2011-12-28 17:00:00	SPY	ETF	124.91	125.01	124.89	124.99	356523.0
2011-12-28 17:30:00	SPY	ETF	125.0	125.0	124.96	124.98	30616.0
2011-12-28 18:00:00	SPY	ETF	124.98	125.12	124.92	125.12	631823.0
2011-12-28 18:30:00	SPY	ETF	125.1	125.15	125.09	125.14	24240.0
2011-12-28 19:00:00	SPY	ETF	125.14	125.21	124.96	125.06	56245.0
2011-12-28 19:30:00	SPY	ETF	125.09	125.14	125.03	125.07	29000.0
2011-12-28 05:00:00	QQQ	ETF	56.21	56.21	56.21	56.21	100.0
2011-12-28 06:30:00	QQQ	ETF	56.25	56.26	56.25	56.26	1300.0
2011-12-28 07:00:00	QQQ	ETF	56.24	56.3	56.24	56.3	4500.0
2011-12-28 07:30:00	QQQ	ETF	56.29	56.29	56.28	56.29	15300.0
2011-12-28 08:00:00	QQQ	ETF	56.29	56.29	56.25	56.25	82013.0
2011-12-28 08:30:00	QQQ	ETF	56.26	56.3	56.26	56.28	153149.0
2011-12-28 09:00:00	QQQ	ETF	56.28	56.29	56.07	56.16	135131.0
2011-12-28 09:30:00	QQQ	ETF	56.17	56.26	55.82	55.86	5128500.0
2011-12-28 10:00:00	QQQ	ETF	55.86	56.01	55.75	55.78	2808416.0
2011-12-28 10:30:00	QQQ	ETF	55.78	55.83	55.71	55.79	1869904.0
2011-12-28 11:00:00	QQQ	ETF	55.78	55.84	55.72	55.73	1478409.0
2011-12-28 11:30:00	QQQ	ETF	55.72	55.75	55.63	55.71	1924771.0
2011-12-28 12:00:00	QQQ	ETF	55.71	55.77	55.62	55.715	1407180.0
2011-12-28 12:30:00	QQQ	ETF	55.73	55.7398	55.58	55.63	1453270.0
2011-12-28 13:00:00	QQQ	ETF	55.63	55.71	55.63	55.6901	959475.0
2011-12-28 13:30:00	QQQ	ETF	55.7	55.79	55.7	55.76	1404881.0
2011-12-28 14:00:00	QQQ	ETF	55.7617	55.775	55.64	55.7	1511857.0
2011-12-28 14:30:00	QQQ	ETF	55.7	55.718	55.64	55.67	1148910.0
2011-12-28 15:00:00	QQQ	ETF	55.67	55.715	55.46	55.48	3428388.0

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

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