PREVIEW / etf_30min / 2018-10-10

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-10.parquet
  size:    523 KB
  rows:    18,027

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
2018-10-10 04:00:00	SPY	ETF	287.45	287.45	287.21	287.21	608.0
2018-10-10 04:30:00	SPY	ETF	287.27	287.54	287.27	287.31	4411.0
2018-10-10 05:00:00	SPY	ETF	287.26	287.39	287.24	287.39	3100.0
2018-10-10 05:30:00	SPY	ETF	287.44	287.49	287.23	287.26	8740.0
2018-10-10 06:00:00	SPY	ETF	287.34	287.51	287.34	287.48	5850.0
2018-10-10 06:30:00	SPY	ETF	287.59	287.74	287.59	287.63	15600.0
2018-10-10 07:00:00	SPY	ETF	287.59	287.8	287.56	287.79	55514.0
2018-10-10 07:30:00	SPY	ETF	287.76	287.76	287.12	287.16	122910.0
2018-10-10 08:00:00	SPY	ETF	287.4	288.01	286.69	286.82	408633.0
2018-10-10 08:30:00	SPY	ETF	286.84	286.9	286.44	286.7	523479.0
2018-10-10 09:00:00	SPY	ETF	286.73	286.9	286.59	286.84	352124.0
2018-10-10 09:30:00	SPY	ETF	286.83	286.91	284.59	284.72	14399677.0
2018-10-10 10:00:00	SPY	ETF	284.735	285.05	284.0	284.725	16599996.0
2018-10-10 10:30:00	SPY	ETF	284.72	284.99	283.95	284.26	9770896.0
2018-10-10 11:00:00	SPY	ETF	284.27	284.36	282.69	283.51	15020441.0
2018-10-10 11:30:00	SPY	ETF	283.51	283.75	282.75	283.12	10075298.0
2018-10-10 12:00:00	SPY	ETF	283.11	283.88	282.74	283.25	9995581.0
2018-10-10 12:30:00	SPY	ETF	283.24	283.5875	282.87	283.03	6546886.0
2018-10-10 13:00:00	SPY	ETF	283.03	283.8	282.31	283.35	7094844.0
2018-10-10 13:30:00	SPY	ETF	283.33	283.56	282.66	282.85	6080095.0
2018-10-10 14:00:00	SPY	ETF	282.84	282.95	281.63	282.03	11135622.0
2018-10-10 14:30:00	SPY	ETF	282.03	282.35	281.05	281.63	10724888.0
2018-10-10 15:00:00	SPY	ETF	281.63	281.635	280.03	280.9977	14424251.0
2018-10-10 15:30:00	SPY	ETF	280.99	281.03	277.88	278.17	47497085.0
2018-10-10 16:00:00	SPY	ETF	278.17	287.4002	276.97	277.17	23139718.0
2018-10-10 16:30:00	SPY	ETF	277.15	278.3	276.22	276.24	2074172.0
2018-10-10 17:00:00	SPY	ETF	276.28	281.52	276.13	276.39	1622896.0
2018-10-10 17:30:00	SPY	ETF	276.37	282.389	276.37	276.52	2737505.0
2018-10-10 18:00:00	SPY	ETF	276.6	278.3	276.25	276.86	271747.0
2018-10-10 18:30:00	SPY	ETF	276.86	277.01	276.74	277.01	97773.0
2018-10-10 19:00:00	SPY	ETF	277.03	277.45	277.03	277.3599	140211.0
2018-10-10 19:30:00	SPY	ETF	277.32	277.32	276.4	276.7	99479.0
2018-10-10 04:00:00	QQQ	ETF	179.49	179.49	179.22	179.22	21950.0
2018-10-10 04:30:00	QQQ	ETF	179.2	179.53	179.2	179.33	51215.0
2018-10-10 05:00:00	QQQ	ETF	179.21	179.38	179.16	179.38	3100.0
2018-10-10 05:30:00	QQQ	ETF	179.34	179.37	179.28	179.28	500.0
2018-10-10 06:00:00	QQQ	ETF	179.33	179.43	179.32	179.35	159840.0
2018-10-10 06:30:00	QQQ	ETF	179.35	179.52	179.33	179.36	62159.0
2018-10-10 07:00:00	QQQ	ETF	179.36	179.53	179.34	179.52	35861.0
2018-10-10 07:30:00	QQQ	ETF	179.49	179.5	178.8	178.87	180969.0
2018-10-10 08:00:00	QQQ	ETF	178.88	179.87	178.55	178.62	289355.0
2018-10-10 08:30:00	QQQ	ETF	178.73	178.73	178.37	178.55	329066.0
2018-10-10 09:00:00	QQQ	ETF	178.53	178.67	178.34	178.56	218519.0
2018-10-10 09:30:00	QQQ	ETF	178.55	178.62	175.94	176.22	12597130.0
2018-10-10 10:00:00	QQQ	ETF	176.23	176.79	175.579	176.48	10048348.0
2018-10-10 10:30:00	QQQ	ETF	176.47	176.79	175.93	176.2366	5452300.0
2018-10-10 11:00:00	QQQ	ETF	176.2499	176.3799	174.85	175.65	6793465.0
2018-10-10 11:30:00	QQQ	ETF	175.63	175.99	175.0796	175.39	4333548.0
2018-10-10 12:00:00	QQQ	ETF	175.35	176.14	174.925	175.72	4275750.0
2018-10-10 12:30:00	QQQ	ETF	175.71	175.79	175.26	175.3335	3184125.0

> showing 50 of 18,027 rows — these rows as CSV

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